Hi foff,

If you only need to sparate the number from the rest of the text, you could
use these formulae:

=LEFT(A1,FIND(" ",A1)-1)
=TRIM(MID(A1,FIND(" ",A1),LEN(A1)))

Reagards,
KL


"foff" wrote in message
...

funniest thing, excel asked me to correct it and offered this:

=MID(A1,SEARCH(" ",A1,1),LEN(A1)-SEARCH(" ",A1,1))

Which is just a bracket in the end could've sworn I tried it.

EDIT:

Ok this one does it:

=MID(A1,SEARCH(" ",A1,1)+1,LEN(A1)-SEARCH(" ",A1,1))


--
foff
------------------------------------------------------------------------
foff's Profile:
http://www.excelforum.com/member.php...o&userid=26272
View this thread: http://www.excelforum.com/showthread...hreadid=395640