Separate parts of a name into three cells

L

Liz C

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
 
M

Mike H

Hi,

Select the column of data then

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

Liz C

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make elements in a row space between instead of wrapping when choosing multiple columns 0
Combining three files when middle file has sections with endnotes 2
Parsing full name into salutation, First, middle, last, Suffix 1
Merging from an Excel file with graphics 1
Put parts of cell in separate columns 0
Separate names into columns 3
Space at end of multi page list to accommodate new entries 1
parsing a full name out into Last, First, Middle 2

Top