#589216 - 01/28/1302:53 PMHELP! Alphabetize by last name?
Acumowchek
Blink
Registered: 12/29/07
Posts: 1793
Loc: Petaluma, CA
I've been given 3 lists which contain hundreds of names each. Is there a way to alphabetize by last name? I can sort ascending using Pages, but only works on the first name. I saw a tutorial online that says Word can alphabetize using "Word 2" in the sort drop down menu, but Office 2010 doesn't have it… Any suggestions?
#589224 - 01/28/1303:22 PMRe: HELP! Alphabetize by last name?
[Re: Acumowchek]
iRock
Livin' on the road my friend
Registered: 05/19/01
Posts: 10169
Loc: Pacific NW, USA
There are actually online sorters you may be able to try. Here are some Google results. (note:see next post) Hope it helps. There was somewhere in InDesign to do it if you have that. CS2 is free online.
#589285 - 01/28/1309:54 PMRe: HELP! Alphabetize by last name?
[Re: MrB]
Acumowchek
Blink
Registered: 12/29/07
Posts: 1793
Loc: Petaluma, CA
I was dwelling on it tonight and thought if I could replace column A (First names), with column B (Last names), my world could be alright again. It can't be that simple, can it?
#589324 - 01/29/1311:08 AMRe: HELP! Alphabetize by last name?
[Re: MrB]
yoyo52
Nothing comes of nothing.
Registered: 05/25/01
Posts: 28778
Loc: PA, USA
Yep--I was going to suggest importing the list into Excel and doing a sort that way. But that would mean making the lists delimited somehow. I wonder if you could do a Find and Replace in Word, changing spaces to commas, and importing the list as a comma-delimited file into Excel.
_________________________ MACTECHubi dolor ibi digitus
#589325 - 01/29/1311:19 AMRe: HELP! Alphabetize by last name?
[Re: yoyo52]
Acumowchek
Blink
Registered: 12/29/07
Posts: 1793
Loc: Petaluma, CA
Sorted Column C to organize the 3 lists, then deleted column. Switched Column A (Last Names) with B (First Names) and merged cell, which created a character Tab between the words. Copy and pasted into Illustrator (Which was my destination for the whole thing), and used Find and Replace to change the Tabs to a Space. Don't know if it's the correct way of doing it, but it worked! :-P
#589333 - 01/29/1301:15 PMRe: HELP! Alphabetize by last name?
[Re: yoyo52]
MrB
I invented modding!
Registered: 08/28/03
Posts: 6396
Loc: SE Kansas
I've never been an expert with Word, but seems like I remember that one can convert to a list then copy tht list into excel into columns. I could be wrong about this, though
Since I quit teaching, I've had little use of excel, but when I was teaching, I had a good handle on it.
Dave
_________________________
There are 10 kinds of people. Those that understand binary and those that don't.
#589388 - 01/30/1307:10 AMRe: HELP! Alphabetize by last name?
[Re: Jim_]
Acumowchek
Blink
Registered: 12/29/07
Posts: 1793
Loc: Petaluma, CA
Quote:
Welcome to 1995
Alright, alright. I was sick that day. "Honest... I ran out of gas. I... I had a flat tire. I didn't have enough money for cab fare. My tux didn't come back from the cleaners. An old friend came in from out of town. Someone stole my car. There was an earthquake. A terrible flood. Locusts! IT WASN'T MY FAULT, I SWEAR TO GOD! "
Previous Topic
Index
