Sorting Names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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

List sorting and macros 3
VBA - retrieve data on last create named range from previous inserted named range 0
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
Excel VBA help: Text file formatting 19
Named Range maker code 9
Move last names to front 4
Modify Claus code "Sub Array_Var_Column_Sort()" 27
Macro for Special Sorting 4

Back
Top