Only numeric value

 Ray -

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:

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.