Delete specific rows of data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roger Bell - 19 Jun 2007 04:45 GMT

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

Reply to this Message

Max - 19 Jun 2007 07:39 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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

Reply to this Message

Roger Bell - 19 Jun 2007 08:25 GMT

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

> One quick way ..
>
[quoted text clipped - 7 lines]
> >
> > Thanks for any help

Reply to this Message

Max - 19 Jun 2007 08:40 GMT

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.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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 to this Message