Re: Advanced filter
- From: "Anne Troy" <ng@xxxxxxxxxxxxxxxxxx>
- Date: Thu, 22 Sep 2005 20:59:32 -0400
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@xxxxxxxxxxxx> wrote in message
news:uwymHP9vFHA.2348@xxxxxxxxxxxxxxxxxxxxxxx
>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@xxxxxxxxxxx
> avanti@xxxxxxxxxxxxx
> avt.gmbh@xxxxxxxxxxx
> ayrexir@xxxxxxxxxxxxxxxxxxxx
> b@xxxxxxxxxxxxx
> bags@xxxxxxxxxxx
> bairaudi@xxxxxxxxxxxx
>
> How do I use advanced filter to delete such selections? Others might
> be .cn, .tw. etc.
>
> Thanks you
>
>
.
- References:
- Advanced filter
- From: Lewis Shanks
- Advanced filter
- Prev by Date: Re: shade every other row, automatically
- Next by Date: Re: Excel 97 won't work on new computer
- Previous by thread: Advanced filter
- Next by thread: Change Comment location?
- Index(es):
Relevant Pages
|
