Sort column with first and last name by last name

  • Thread starter Thread starter rpielet
  • Start date Start date
R

rpielet

Hello,
I have a mailing list with 10,000 names. The first cell has first an
last name in the same cell. First name is listed first. Is there
formula to sort and/or separate text in a cell. I would like to sort o
separate the first name from the last in the cell to allow for a mai
merge by name. Using Excel 2002. Thank you
 
If you have just first and last names separated by a space, Data>Text to
Columns would be the easiest method to split into two columns.

If more than that, like names with van or von or de etc. you may need a
different method.

Chip Pearson has a demo workbook and formulas on his FirstLast page.

http://www.cpearson.com/excel/FirstLast.htm

Gord Dibben Excel MVP
 
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

How do I separate first and last names into two columns? 2
Sort First and last name in single cell 3
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
Separate First, Last Names 2
Matching Names 5
Sorting full name into 2 columns by first name and last name 3
change first name last name to last name first name 3
how to arrange list by first or last name 1

Back
Top