Obtain numeric from alphanumeric string
With
A1: (text ending with a numeric value)
This formula returns the number at the end of the string:
B1: =MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"01234 56789")),99)*1
Does that help?
Post back if you have more questions.
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
"Manj" wrote in message
...
What is the easy method of obtain numeric from alphanumeric string in an
excel column:-
ab 0.25 I want 0.25
jds 0.125 I want 0.125
|