Separating names from one cell

[Guest]

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

 

[Guest]

Hi

Have a look at Data/Text to columns. If you use <space> as a delimiter it
should do the job for you. Select the column before you start, and make a
copy of the sheet too, in case it all goes horribly wrong!

Andy.

 

[Niek Otten]

Data>Text to columns

 

[Guest]

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