Split string and perform function on them in Excel

by Rubin|Published April 28, 2022

I have cells of the form –

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