ExcelBanter - Obtain numeric from alphanumeric string

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Obtain numeric from alphanumeric string (https://www.excelbanter.com/excel-discussion-misc-queries/180062-obtain-numeric-alphanumeric-string.html)

Manj

Obtain numeric from alphanumeric string

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

Ron Coderre

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

Mike H

Obtain numeric from alphanumeric string

For the 2 examples you gave this would work:-

=MID(A1,FIND(" ",A1,1)+1,LEN(A1))

Mike

"Manj" wrote:

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

Mike H

Obtain numeric from alphanumeric string

an afterthought

=MID(A1,FIND(" ",A1,1)+1,LEN(A1))*1

Mike

"Manj" wrote:

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

All times are GMT +1. The time now is 04:38 AM.