Sorting 3 Comma Seperated E-Mail Lists in Excel 2007

[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.

[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?

[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...