Name List
 

I have a list of names such as appearing as Last, First. The names appear in
one cell. How do I put the last name in a cell and the first name in a
different cell and eliminate the comma.

Name List
 

Highlight the column, Select Data/Text to Columns, Select Delimited <Click
Next,

Select Comma <Click Finish

Regards

Tim

"Janey" wrote in message
...
I have a list of names such as appearing as Last, First. The names appear
in
one cell. How do I put the last name in a cell and the first name in a
different cell and eliminate the comma.

Name List
 

There may be a better way, but one way is to save the file as a unified code
txt file then when you open the .txt file in excel it will need to go through
the text import wizard in which you can choose delimited data. In this
situation the comma becomes a delimiter and seperates your data in to two
seperate columns. Depending on your original data you may have to deal with
some quotation marks (look for the "text qualifier" box in the wizard). Good
luck.


"Janey" wrote:

I have a list of names such as appearing as Last, First. The names appear in
one cell. How do I put the last name in a cell and the first name in a
different cell and eliminate the comma.