G
Guest
I have a spreadsheet with various words and numbers in each cell. The
arrangement of numbers in the string can vary. I want to extract from the
text string, the first 3 numbers as numbers.
Example
dog a cat 45672 223 12.42 mouse caught
I want to parse the above string (which is in a cell) and get
45672
223
12.42
arrangement of numbers in the string can vary. I want to extract from the
text string, the first 3 numbers as numbers.
Example
dog a cat 45672 223 12.42 mouse caught
I want to parse the above string (which is in a cell) and get
45672
223
12.42