View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pierre Pierre is offline
external usenet poster
 
Posts: 193
Default Sort by town name, which follows first name and initial; period; andcomma.

Have a list of club members, and would like to sort this list by
locale or town name.
The text follows this sequence:
Rick J., Ocala, CA
Sue R., Elmwood Forest, CA
Charlie T., Sacramento, CA

Is there an effective way to sort alphabetically by town name?
The result would be Sue, followed by Rick, and then Charlie.
There are 300+ entries; manually reformatting would be possible, but
not very timely.

TIA for any ideas.
Pierre