Hi,

Use the formula,

=1*LEFT(A1,FIND(" ",A1)-1)

The formula should work if the alphanumeric strings are of the format you
shown in your examples, i.e., number and unit separated by a space.

Regards,
B. R. Ramachandan

"Old Tone" wrote:

How do I extract decimal numbers from alphanumeric strings to perform
calculations on the number, eg 25.1 km or 100 m.