So, do you want to delete the rows where there is no email address? If
so, just apply autofilter to that column and select "Blanks" from the
pull-down. Then highlight the rows that are visible and click on Edit
| Delete Row. Select All from the filter pull-down to see the
remaining rows.

Hope this helps.

Pete

On Nov 16, 7:48 pm, Susienak
wrote:
In Excel 2007, I have a list of names, addresses, county, phone number and
email addresses. Not every name has an email address. So if I sort the list
into just county and email address Im left with ALOT of blank cells where
there were no email addresses. Ive done a sort by county cell a-z and added a
level and sorted by email cell a-z.... so all the blank cells are together by
county. Is there a faster way to delete the blank cells that are left other
than deleting one cluster at a time? It takes about 30 minutes that way and I
have 50 lists to do! Help!!! lol Anyone with an answer???

Thanks, Susan