| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing alphabetizing entries
I have a list of complete names in a single column alphabetized by first
name. Examples: A. C. Johnson, Adrian Smith, Alex J. Anderson, Allan Del Boca, Andrew Paul Lutz, Jr. PRIMARY OBJECTIVE: How can I alphabetize this list by last name to get: Anderson, Del Boca, Johnson, Lutz (or Lutz, Jr.), Smith? SECONDARY OBJECTIVE: Also, can I do it and "keep" the rest of the name in the entry? Thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing the Duplicate entries | Excel Worksheet Functions | |||
| Changing Entries to Proper and Upper Case Q | Excel Worksheet Functions | |||
| changing data entries | Excel Discussion (Misc queries) | |||
| Alphabetizing | Excel Discussion (Misc queries) | |||
| MRU list - entries keep changing | Excel Discussion (Misc queries) | |||
Threaded Mode
