| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ? sort data in a drop down box w/ initial cell entry | Excel Worksheet Functions | |||
| Ignoring Initial Articles in Field Sort | Excel Discussion (Misc queries) | |||
| How Do I organize sheets and clients by town? | Excel Worksheet Functions | |||
| automatically insert town name after entering zip code | Excel Discussion (Misc queries) | |||
| sort numbers based on initial digit. | Excel Discussion (Misc queries) | |||
Threaded Mode
