Filtering part of text

[Happy]

I have a list of email addresses.

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

How to do this?

 

[Peo Sjoblom]

Use data>filter>auto 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)