How do I delete multiple e-mails?

How to find and delete multiple entries from an excel list of emails?

• I have an excel file with a lot of emails about 2000 from my university. I need to delete about 500 entries from it which are in a word file. The emails in the excel sheet are ...show more

• Answer:

  Copy the addresses to delete somewere in excel (other than the 2000 addresses list) and make sure that they are in one column as well and that they do not contain any non printed characters (do a replace spaces with voids). Then give to this list a name say 'todelete' Supposing that the 2000 addresses list starts listing from cell A1, and that column B is empty then in cell b1 insert the function: vlookup(A1;todelete;1;0) and fill down to cover the entire 2000 addresses list. Select together the data in columns A and B and sort for column B Delete from column A where there is a match among the two lists