View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
puzzlesnok puzzlesnok is offline
external usenet poster
 
Posts: 2
Default 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.