find cell that contains text and delete entre row
 

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

find cell that contains text and delete entre row
 

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

find cell that contains text and delete entre row
 

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


"Cristi R" wrote:

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

find cell that contains text and delete entre row
 

Hi Ron,

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

Regards,
Cristi

"Ron de Bruin" wrote:

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