Zend certified PHP/Magento developer

Split string and perform function on them in Excel

I have cells of the form –

enter image description here

and I want to convert each cell into the formula –

= (first number)*10^(second number+2), where the first and second numbers are the ones that come before and after the comma. Whats the best way to do it?

Example –

=30*10^2 or

=9*10^8