find cell that contains text and delete entre row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
Hi Ron,

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

Regards,
Cristi
 
Back
Top