#589324 - 01/29/1311:08 AMRe: HELP! Alphabetize by last name?
[Re: MrB]
yoyo52
Nothing comes of nothing.
Registered: 05/25/01
Posts: 28788
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: 1805
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: 6413
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: 1805
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
