Try these formulae

=LEFT(A1,FIND(CHAR(160),A1&CHAR(160))-1)

=SUBSTITUTE(A1&CHAR(160),B1&CHAR(160),"")

--
__________________________________
HTH

Bob

"SarahJ" wrote in message
...
I have First and last names that were downloaded from a website. The names
appear to be separated by a space, but low and behold when I tried to use
text to columns to separate them it did not work. I had to go and change
what ever is separating the name to a space on one of the records to get
it
to work. Any ideas on how to accomplish this and what might possibly be
separating the names.