You can extract the number with this formula:

=MID(A1,11,SEARCH(" ",A1,11)-11)*1

assuming the text is in A1. Copy down for the other numbers.

Hope this helps.

Pete

On Apr 8, 1:01 am, Arturo wrote:
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 11'th 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