Quick assist, number extraction

[NateMarx]

I have a cell with "42059 Completed QualityReviewed"
in it.
I just want to extract the number itself to another cell.

Any help would be appreciated.

 

[Scott Huish]

If the number is always first as in your sample:

=LEFT(A1,FIND(" ",A1&" "))+0

 

[NateMarx]

If the number is always first as in your sample:

=LEFT(A1,FIND(" ",A1&" "))+0

Thank you but, that didn't seem to work.

A first got the #VALUE ! error, then I removed the spaces between the quotations and only the first number showed up.

Little more help?

 

[Joe4]

1Are the double-quotes actually part of the string too?

On your particular example you quoted above, please let us know what the following formulas return (assuming your entry is in cell A1):
=LEFT(A1,1)
=CODE(MID(A1,6,1))

 

[Scott Huish]

If the quotes are actually in the cell:
=MID(A1,2,FIND(" ",A1)-1)+0