Hey, this worked like a charm!

Thanks everyone for your time!


"Jason Morin" wrote:

To pull out the Surname into a cell:

=LEFT(A1,FIND(" ",A1)-1)

The rest of it:

=MID(A1,FIND(" ",A1)+1,999)

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi,

I have data (names) which appear with Surname first,
with all other names
after that. (all in one cell). For example:

Earles Prof Stanley William Edward

What I want to do, is split this so that the first word
(in this case
"Earles" stays, and the rest is shifted into a new
column.

Any ideas?

PS...I cant get Data, text to columns to work!
.