Advanced filter

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:
autoweigh@mcimail.com
avanti@cadvision.com
avt.gmbh@city.web.de
ayrexir@tandem-resources.com
b@dragonmax.com
bags@smurfit.com
bairaudi@argonics.com

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

"Lewis Shanks" <lshanks@npgcable.com> wrote in message
news:uwymHP9vFHA.2348@TK2MSFTNGP15.phx.gbl...
>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:
> autoweigh@mcimail.com
> avanti@cadvision.com
> avt.gmbh@city.web.de
> ayrexir@tandem-resources.com
> b@dragonmax.com
> bags@smurfit.com
> bairaudi@argonics.com
>
> How do I use advanced filter to delete such selections? Others might
> be .cn, .tw. etc.
>
> Thanks you
>
>