Need to extract numbers from a cell and convert to number values. Please help.

Originally Posted by Speshul

For the numbers;
=LEFT(A1,FIND(" ",A1,1)-1)
If it's always 3 letters, you can use
=RIGHT(A1,3)

If the letters are variable length, as long as there are no spaces use:
=MID(A1,FIND(" ",A1,1)+1,LEN(A1))

Originally Posted by martindwilson

just add 0 to the results,
=LEFT(A1,FIND(" ",A1,1)-1)+0
other ways are
=--LEFT(A1,FIND(" ",A1,1)-1)
=LEFT(A1,FIND(" ",A1,1)-1)*1

you guys are legends! thanks so much!