Many thanks. It looks a bit fearsome but works fine.

Old Tone

"Domenic" wrote:

Try...

=LOOKUP(9.99999999999999E+307,--LEFT(A1,ROW(INDIRECT("1:"&LEN(A1)))))

....where A1 contains your alpha-numeric string.

Hope this helps!

In article ,
"Old Tone" <Old wrote:

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