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

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" <mlf@discussions.microsoft.com> wrote in message
news:49E45B16-8BF6-4BC2-AA17-A212C9195BE5@microsoft.com...
>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

Data>Text to columns

--
Kind regards,

Niek Otten

"mlf" <mlf@discussions.microsoft.com> wrote in message
news:49E45B16-8BF6-4BC2-AA17-A212C9195BE5@microsoft.com...
>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

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:

> Data>Text to columns
>
> --
> Kind regards,
>
> Niek Otten
>
> "mlf" <mlf@discussions.microsoft.com> wrote in message
> news:49E45B16-8BF6-4BC2-AA17-A212C9195BE5@microsoft.com...
> >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
>
>
>