Only numeric value

Closed
Report
-
 Ray -
Hello,


i can read only numeric value at given bellow

Sell 45621 aa aaaaaa
Sell 4561 aa aaaaaa
Sell 456 aa aaaaaa
Sell 56 aa aaaaaa
Sell 6 aa aaaaaa

1 reply

If you mean you want to extract only the numeric value within the string then this will work:

{=1*MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$20),1)),0),COUNT(1*MID(A1,ROW($1:$20),1)))}
Note: This is an array so you will have to press CTRL-SHIFT-ENTER instead of just ENTER

The $20 is the len of the string from which you want to extract the number.
0