Page 1 of 1
Sorting 3 Comma Seperated E-Mail Lists in Excel 2007
Posted: Tue Nov 25, 2008 2:29 pm
by Apoptosis
Is there a way to take multiple comma seperated e-mail lists and sort and remove duplicates in Excel 2007 or any other program for that matter? If I try to insert the copy/pasted data into excel they all go into one cell. Not sure if anyone of you guys have a quick fix for doing this sort.
Re: Sorting 3 Comma Seperated E-Mail Lists in Excel 2007
Posted: Tue Nov 25, 2008 2:54 pm
by bubba
take the CSV file, dump it back into outlook express and tell it not to import duplicates, then re-export the CSV file when its done?
Re: Sorting 3 Comma Seperated E-Mail Lists in Excel 2007
Posted: Tue Nov 25, 2008 6:09 pm
by Jakey The Avatar
Jakey's Girl Tree says: (<--- that's my fiancee)
Copy and paste your list into a text file (.txt so there is no formatting)
Then in Excel:
Click data.
From text.
Select your file.
Choose "delimited"
Click Next
Uncheck Tab
Check Comma
Click Next
Finish
That should import everything into separate cells.
*EDIT*
I just realized you probably meant you had 3 lists which you were trying to consolidate.
At first I thought you had a list that went something like (first name, last name, e-mail).
So, using the method outlined above you could import all the separate lists and then use Excels sort feature.
I don't know how to remove duplicates...