| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Address List Sort Help Needed - 1 attachment
I have an address list that I need to sort by the addressee's last name. My
problem is that some of the adressees are businesses and some have titles. Each address is in a separate row. Should I use a formula to replace the titles (Mr. Mrs. Dr.) with nothing? How do I handle sorting the businesses? I would want to sort these by the first word in the name. The people I would want to sort by their last name, ignoring Jr. Sr. II, III. Can this be done? I am attaching an Excel list for your consideration. Thank you!! Scott |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort text list by character length - how? | Excel Worksheet Functions | |||
| HOW DO I MAKE ADDRESS LABELS OUT OF LIST IN EXCEL DOC? | Excel Discussion (Misc queries) | |||
| sort list using vba | Excel Discussion (Misc queries) | |||
| loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) | |||
| Loop through email address list to send e-mails | Excel Discussion (Misc queries) | |||
Threaded Mode
