Hi Cristi

You can do it with AutoFilter

CustomDoes 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 F5SpecialCurrent regionOK
3) Press Alt ; (Alt plus the semicolon) to select all visible data or F5 Special .... "Visible cells only"
4) EditDelete Rows



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Cristi R" wrote in message ...
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