Extract Numerics only
If your numbers are not more than 15 digits in length, try...
=LOOKUP(9.99999999999999E+307,--MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A
1&"0123456789")),{1,2,3,4,5,6,7,8,9,10,11,12,13,14 ,15}))
Otherwise, try...
=LOOKUP(9.99999999999999E+307,--MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A
1&"0123456789")),ROW(INDIRECT("1:"&LEN(A1)))))
Hope this helps!
In article ,
"Corey" wrote:
Hello. I have a column with data that contain numerics and text:
ON 3127
ON2679
O/F 20R
OFF///130H
Is there a formula I can input in an adjacent cell to only pull out the
numbers to give me the following:
3127
2679
20
130
Any help is appreciated. Thanks!
|