Help with sorting blanks out of a list

[Guest]

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

 

[Pete_UK]

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

 

[Guest]

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.

 

[David Biddulph]

So if you want to save as a csv, save as a csv. That option was still
available to you. The dialogue was merely trying to warn you that a csv is
purely a text file, and doesn't have any of the more complicated features of
an Excel file (such as formulae). It will merely have text strings,
separated by commas.

We don't know what format is needed for your mailing program. The mail
merge feature of Microsoft Word, for example, will work happily with an
Excel file as its input.