Splitting Cell Data From One Cell Into Two

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Spencer - 07 Apr 2007 01:00 GMT

Hello, suppose you have an address or telephone list in which the first and
last name are not in seperate cells, but in the same cell. I would like to
somehow seperate the first and last name into two seperate cells. Is there
any way to do this automatically?

Thanks, Spence

Reply to this Message

Pete_UK - 07 Apr 2007 01:06 GMT

If you have a space separating the two items, you may think about
using Data | Text-to-columns to split the data, specifying <space> as
the delimiter.

Alternatively, you could use a formula to get the left-hand item and
another formula to get the right-hand item, using SEARCH to find which
character is the space.

Hope this helps.

Pete

> Hello, suppose you have an address or telephone list in which the first and
> last name are not in seperate cells, but in the same cell. I would like to
> somehow seperate the first and last name into two seperate cells. Is there
> any way to do this automatically?
>
> Thanks, Spence

Reply to this Message

Spencer - 07 Apr 2007 01:19 GMT

Thanks for the quick reply. The text to column solution was exactly what I
was looking for.

Spence

> If you have a space separating the two items, you may think about
> using Data | Text-to-columns to split the data, specifying <space> as
[quoted text clipped - 17 lines]
>>
>> Thanks, Spence

Reply to this Message

Pete_UK - 07 Apr 2007 01:21 GMT

Glad it worked for you - thanks for feeding back.

Pete

> Thanks for the quick reply. The text to column solution was exactly what I
> was looking for.
[quoted text clipped - 24 lines]
>
> - Show quoted text -

Reply to this Message

Rate this thread: