thanks for reply.
I used the command you mentioned (FIND(" ",A1)) but it returns 13.

"Roger Govier" wrote in message
...
Hi

=FIND(" ",A1) returns 4
=LEFT(A1,FIND(" ",A1)-1) returns bob
--
Regards

Roger Govier


"Rasoul Khoshravan" wrote in message
...
a1= bob 1001
there is 10 space between bob and 1001.
I want to extract bob and 1001.
find " " command retuerns the position of last " ", in this case 13. How
can I extract only "bob".