Thread
:
how to extract decimal numbers from alphanumeric strings in Excel
View Single Post
#
9
Posted to microsoft.public.excel.misc
Don Guillett
Posts: n/a
how to extract decimal numbers from alphanumeric strings in Ex
glad to help
--
Don Guillett
SalesAid Software
"Tim" wrote in message
...
Great Thanks!
"Don Guillett" wrote:
try
to get 16:30
=TEXT(LEFT(D2,FIND("m",D2)-1)&":"&MID(D2,FIND(" ",D2),FIND("s",D2)-FIND("
",D2)),"hh:mm")
to get 16.5
=LEFT(D2,FIND("m",D2)-1)&TEXT(MID(D2,FIND(" ",D2),FIND("s",D2)-FIND("
",D2))/60,".#")
--
Don Guillett
SalesAid Software
"Tim" wrote in message
...
how can i do this but with two numbers
Eg, 16m 30s
This is 16 minutes 30 seconds.
and if you know this, how can i then turn this to read a a decimal, ie,
change 16m 4s to read 16.5
Tim
"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.
Reply With Quote