Separate parts of a name into three cells
 

I have a name cell that has last, first middle. How can I separate the last
into one cell, the first in the next cell and the middle in the next. The
last and first have a , and a space between them and there is a space between
the first and the middle.

Thanks in advance for your help!

Liz

Separate parts of a name into three cells
 

Hi,

Select the column of data then

Data|Text to columns - Delimited
Next
Check space and comma
Finish

"Liz C" wrote:

I have a name cell that has last, first middle. How can I separate the last
into one cell, the first in the next cell and the middle in the next. The
last and first have a , and a space between them and there is a space between
the first and the middle.

Thanks in advance for your help!

Liz

Separate parts of a name into three cells
 

That was too simple. Duh! I've even done it before but couldn't remember.
Thanks, Mike!

"Mike H" wrote:

Hi,

Select the column of data then

Data|Text to columns - Delimited
Next
Check space and comma
Finish

"Liz C" wrote:

I have a name cell that has last, first middle. How can I separate the last
into one cell, the first in the next cell and the middle in the next. The
last and first have a , and a space between them and there is a space between
the first and the middle.

Thanks in advance for your help!

Liz

Separate parts of a name into three cells
 

your welcome

"Liz C" wrote:

That was too simple. Duh! I've even done it before but couldn't remember.
Thanks, Mike!

"Mike H" wrote:

Hi,

Select the column of data then

Data|Text to columns - Delimited
Next
Check space and comma
Finish

"Liz C" wrote:

I have a name cell that has last, first middle. How can I separate the last
into one cell, the first in the next cell and the middle in the next. The
last and first have a , and a space between them and there is a space between
the first and the middle.

Thanks in advance for your help!

Liz