Pulling a # from a sheet bound text string
I have several rows with the following beginning text as follows:
There are 1 projects ABC€¦
There are 14 projects ABC€¦
There are 140 projects ABC€¦
There are 1400 projects ABC€¦
Been experimenting with MID, LEFT, RIGHT to no avail where I cannot figure
out how to pull the number starting at the 11th place out. That number
could be from 1 to 1000. I tripping over the varying number of spaces any
number in a cell might be as depicted above. The text flowing €˜project,
'ABC...' varies also€¦ Any direction as how to combine functions would be
appreciated.
Sincerely,
Arturo
|