Change 2 names in one cell to one name in 2 cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wab - 18 Jun 2005 00:26 GMT

Is there a way that if there are two names in one cell (a1), i.e.;
Johnson--Jackson, that they can be changed to be listed in two
different cells, such as, Johnson in cell b1 and Jackson in cell b2. I
have a very long list of names and I do not want to go through the list
and type every thing in again.
Thanks for any assistance you can give me. WAB

Reply to this Message

JE McGimpsey - 18 Jun 2005 00:36 GMT

Use the Data/Text to Columns wizard.

> Is there a way that if there are two names in one cell (a1), i.e.;
> Johnson--Jackson, that they can be changed to be listed in two
> different cells, such as, Johnson in cell b1 and Jackson in cell b2. I
> have a very long list of names and I do not want to go through the list
> and type every thing in again.

Reply to this Message

wab - 18 Jun 2005 11:34 GMT

Thank you!

> Use the Data/Text to Columns wizard.
>
[quoted text clipped - 3 lines]
> > have a very long list of names and I do not want to go through the list
> > and type every thing in again.

Reply to this Message