Hi Pete,

I applied filter to the column and selected blanks from the bottom of the
pull down and all the blank rows disappeared. I then went to sort and sorted
a-z and it all seemed to work fine until I saved the document. When I go back
in to open the document again... all the blank cells are back.

When I save the document a pop-up comes up that says "myfilename.csv may not
be compatible with CSV (Comma delimited). Do you want to keep the workbook in
this format? One of the options it gives says to preserve the features, click
no, then save a copy in the latest Excel format.

Whats the latest Excel format. I need this file to be a CSV format if Im
importing it into a mailing program, dont I?

What do I do? None of my files stayed saved.



"Pete_UK" wrote:

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