find cell that contains text and delete entre row

C

Cristi R

Hi guys,

I am facing a challenge with a DB. One of the columns contains the email
addresses. I would like to find a way to delete the rows that contain in the
email address field a certain domain name. For example, in that column, there
are several email addresses containing the same domain name. And I need to
delete all the rows containing that domain name. Will I need to use a macro??

Many thanks,
Cristi
 
R

Ron de Bruin

Hi Cristi

You can do it with AutoFilter

Custom>Does contain domain name

Then delete the visible data

1) Be sure that the active cell is in the data range
2) Press Ctrl * to select all data or use F5>Special>Current region>OK
3) Press Alt ; (Alt plus the semicolon) to select all visible data or F5> Special .... "Visible cells only"
4) Edit>Delete Rows
 
T

Toppers

Look at Data==>Filter==>AutoFilter

on required column:

Select Custom==>Contains==>noway.com

This will highlight all rows containing "noway.com" which you can then delete

(Backup first!)

HTH
 
C

Cristi R

Hi Ron,

Thank you very much. This group is excellent for unexperienced users like me
to benefit from your experience!

Regards,
Cristi
 
Top