deleting blank entries

[mikeyVo]

I have a series of entries, say column 1-4 have lastname, firstname, phone number and email. Now, I want to delete every entry without an email, is there a way I can automate this without manually searching for the row without the entry and deleting it?

Thanks for your help

[Xcelion]

Hi Mike,

Use Data->AutoFilter ,Filter for blank email and delete the filtered rows


Thanks
Xcelion


"mikeyVo" wrote:

>
> I have a series of entries, say column 1-4 have lastname, firstname,
> phone number and email. Now, I want to delete every entry without an
> email, is there a way I can automate this without manually searching
> for the row without the entry and deleting it?
>
> Thanks for your help
>
>
> --
> mikeyVo
> ------------------------------------------------------------------------
> mikeyVo's Profile: http://www.excelforum.com/member.php...o&userid=34277
> View this thread: http://www.excelforum.com/showthread...hreadid=568209
>
>