Sorting Names
 

I have a rather long list of names (485)with 14 additional cells of information in each row. The originator of the excel file entered the names as first name then last name. My problem is to sort this list by last name. Is there a processs or a specific formula that will help me?

Sorting Names
 

you could go to Data|Text to Column and split the names into 2 columns
then you'll have col A first names, B last and just Sort by col B
hope this helps

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com