Name List

  • Thread starter Thread starter Janey
  • Start date Start date
J

Janey

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.
 
Highlight the column, Select Data/Text to Columns, Select Delimited <Click
Next>,

Select Comma <Click Finish>

Regards

Tim
 
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.
 
You must log in or register to reply here.

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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Switch names 7
Excel help separating / 2
breaking a field out 2
How do I resort names 2
Excel Is this possible?? 3
lookup needed for names in varying order 2
Find and return name of worksheet tab for referenced cell 2

Back
Top