Spliting data in the same cell

**sentinela** · 03-24-2009, 09:00 AM

Hello everyone,

It has been awhile since last I have done this, but how do you split a data in the same cell. For example, I have "Smith, John" in the same cell, and I want to get "Smith" and "John" in two different cells.

Thanks!

**arthurbr** · 03-24-2009, 09:09 AM

Hi,
try Data - Text to columns and use the comma as delimiter

**zbor** · 03-24-2009, 09:13 AM

Or try

Please Login or Register  to view this content.

**sentinela** · 03-24-2009, 09:50 AM

Thanks for the help.

zbor, I couldn't quite get your formula. Although arthurbr's way is a little longer, I think I am going for that. I guess it is simpler.

Thanks anyway.

**arthurbr** · 03-24-2009, 10:31 AM

Sentinela, why do you think the Text to columns solution is longer ?
You can apply it to an entire column, and with a couple of clicks it's ok.
Of course if values are added regularly, you would have to do it each time, while in that case zbor's solution would be easier

**sentinela** · 03-24-2009, 10:47 AM

Arthurbr,
Thanks for all the help.

Unfortunately my data is not all in one column. I have couple breaks in the data with headings in the middle of the document. But, I have done your way, and it worked just fine.

I appreciated your help.