Thread: Delete specific rows of data
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Delete specific rows of data
well, in that case maybe just check "Constants" (instead of "Blanks")
in the "Go To Special" dialog might do it for you?

Instead of:
Press F5 Special Check "Blanks" OK

do:
Press F5 Special Check "Constants" OK

The above of course presumes that the email col would contain only email,
other than blank cells.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Roger Bell" wrote:
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
Reply With QuoteReply With Quote