Advanced filter

  • Thread starter Thread starter Lewis Shanks
  • Start date Start date
L

Lewis Shanks

I have a data base with hundreds of email addresses. I want to filter out
certain addresses from the list, for example those which are clearly not
domestic such as those ending in ".de"

Here is an example of a section of the list:
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)
(e-mail address removed)

How do I use advanced filter to delete such selections? Others might
be .cn, .tw. etc.

Thanks you
 
If it were me, I would probably create a new column. Suppose emails are in
B2 and down. In C2, put =if(right(b2,3)="com","","review")
Copy that formula down. Select ALL of the formulas you placed and, without
moving your cursor, hit Edit-->Paste special, Values, OK.
Then sort by this new column (make sure it's got a header like your other
columns), and review all the ones marked "review". By sorting, you can
quickly delete anything that's not a "com" addy. Delete this extra column
when you're done.
************
Anne Troy
www.OfficeArticles.com
 
Back
Top