Hello all,

I have a list of 20,000 emails (database of our company) on excel and I like
to select ALL the emails which include the Word "wine" in it.

So these emails should be selected:
- (E-Mail Removed)
- (E-Mail Removed)
- (E-Mail Removed)
- mon-(E-Mail Removed)
- (E-Mail Removed)
- etc...

How can I select them all ? There should be around 1000 emails which include
this word in the 20000 contacts...

Should I do a conditionnal formating so I can see them and make the
apropriate changes?

Thanks for your help

Julien.

Apply data>filter>autofilter, from dropdown select custom and contains wine
(note that this will return swine as well <bg>)
then maybe copy visible cells and paste somewhere else


--

Regards,

Peo Sjoblom

"Julien FROGER" <(E-Mail Removed)> wrote in message
news:BFE1963A.50F96%(E-Mail Removed)...
> Hello all,
>
> I have a list of 20,000 emails (database of our company) on excel and I
like
> to select ALL the emails which include the Word "wine" in it.
>
> So these emails should be selected:
> - (E-Mail Removed)
> - (E-Mail Removed)
> - (E-Mail Removed)
> - mon-(E-Mail Removed)
> - (E-Mail Removed)
> - etc...
>
> How can I select them all ? There should be around 1000 emails which
include
> this word in the 20000 contacts...
>
> Should I do a conditionnal formating so I can see them and make the
> apropriate changes?
>
> Thanks for your help
>
> Julien.
>

Julien,

It's probably easiest just to use the AutoFilter functionality.

Select the range then Data>Filter>AutoFilter. From the drop down i
the column heading select (Custom). In the Custom AutoFilter selectio
box, select "contains" as your first option and type in wine in th
second. Click OK. This will list all addresses with the word wine i
it.

Cheers,

Stev

--
Steve
-----------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...nfo&userid=757
View this thread: http://www.excelforum.com/showthread.php?threadid=49791

Ouah!!!!!!!
Thanks to both of you Peo Sjoblom and Steve!
The autofilter works perfect! I have always used the normal filters and
didn't know we could do that!!!!!!

Thanks very much.

Julien


Le 4/01/06 15:28, dans (E-Mail Removed),
«*SteveG*» <(E-Mail Removed)> a écrit*:

>
> Julien,
>
> It's probably easiest just to use the AutoFilter functionality.
>
> Select the range then Data>Filter>AutoFilter. From the drop down in
> the column heading select (Custom). In the Custom AutoFilter selection
> box, select "contains" as your first option and type in wine in the
> second. Click OK. This will list all addresses with the word wine in
> it.
>
> Cheers,
>
> Steve
>