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 a
email, is there a way I can automate this without manually searchin
for the row without the entry and deleting it?

Thanks for your hel

 

[Guest]

Hi Mike,

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


Thanks
Xcelion