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