Filtering part of text
 

I have a list of email addresses.

I want to delete those email addresses that have these letters: cpf
for example or

How to do this?

Use datafilterauto filter, from dropdown select custom and contains and in
the box put

cpf.

filter, then select the visible area, press F5, click special and select
visible cell only then press
ctrl -

from the dropdown select show all

--
Regards,

Peo Sjoblom

(No private emails please)


"Happy" wrote in message
...
I have a list of email addresses.

I want to delete those email addresses that have these letters: cpf
for example or

How to do this?