| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
| Sorting names in Name box | Excel Worksheet Functions | |||
| Sorting names in Name box | Excel Worksheet Functions | |||
| Sorting a list of names by last name. | Excel Discussion (Misc queries) | |||
| sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
![Danny[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
