Conditionnal Formating Help

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:
- tintin@robertwine.com
- monwine@blabla.com
- mon.wine@blabla.com
- mon-wine@bla.com
- monwine@wine-wine.com
- 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 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

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" <julien@antique-wine.com> wrote in message
news:BFE1963A.50F96%julien@antique-wine.com...
> 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:
> - tintin@robertwine.com
> - monwine@blabla.com
> - mon.wine@blabla.com
> - mon-wine@bla.com
> - monwine@wine-wine.com
> - 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.
>

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 SteveG.2149fy_1136388600.4511@excelforum-nospam.com,
«*SteveG*» <SteveG.2149fy_1136388600.4511@excelforum-nospam.com> 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
>