Thanks for your quick response, Max

What I meant to say was that i want to delete the rows where an email
address does exist. What process would I use for this

Thanks again

"Max" wrote:

One quick way ..

Select the entire email col
Press F5 Special Check "Blanks" OK
This selects all the blank cells in the email col
Then just right-click on the selection Delete Check "Entire row" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Roger Bell" wrote:
Is there a way that you can delete/remove rows of data where a specific
situation applies. For example I want to remove the entire row where email
addresses are blank

Thanks for any help