Separating names from one cell
 

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

Separating names from one cell
 

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.

"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

Separating names from one cell
 

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

Separating names from one cell
 

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