deleting blank entries

  • Thread starter Thread starter mikeyVo
  • Start date Start date
M

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
 
Hi Mike,

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


Thanks
Xcelion
 
Back
Top