Reply to thread

Message: [QUOTE="psg2103, post: 6791803"] hi i use osx10.3.3, a G4 with 500-odd MB of memory and excel 2004 for mac version 11.1.1 i have a problem trying to sort an address list database. i am an excel neophyte and need your help! the problem: i have a list of some 800 addresses for my high school reunion mailing. the fellow who made up the list combined first names and last names into one data column. that means the list sorts by first name. this has some advantages - women who married (and bizarrely the significant number of guys who changed their family names!) can be more easily found. however, for various other reasons, i need to do two things with this list: 1 - move it into an address book format: entourage, apple address book or palm desktop address book; 2 - to move it into an address book, i need to separate the first and last names into distinct fields. is there any formula or macro that i can run (or download and run) thatw oudl allow me to separate the last word (i.e. the last name) in each entry (row) and create a separate column with last names? finally can someone help me figure out how to "lock" the relationship of the database, so that if i sort any one column, or change or delete entries, the data from each row remains locked together (does that make sense? i mean that if i remove one person's address all the other addresses bump up, switching the names tow hich they are attached. if i sort by zip code, the rest of the data stays where it is and everyone gets a new zip code. thanks - peter [/QUOTE]

Verification