Sort column with first and last name by last name

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
 
G

Gord Dibben

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
 
Top