Assuming the names are in Coumn A and separated only by a space,
In B1 put this and copy down to get the first names:

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

In C1 put this and copy down to get the last names:

=MID(A1,FIND(" ",A1,1),99)

Vaya con Dios,
Chuck, CABGx3




"Niek Otten" wrote:

DataText to columns

--
Kind regards,

Niek Otten

"mlf" wrote in message
...
I have a long list of first and last names in one cell, is there a way to
separate them out without having to manually copy, paste, and delete each
one. It would be great to have two columns: first name and last name.

Thanks,
mlf