Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with sorting blanks out of a list
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with sorting blanks out of a list
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with sorting blanks out of a list
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with sorting blanks out of a list
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. -- David Biddulph "Susienak" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Condense out blanks in a list | Excel Discussion (Misc queries) | |||
Removing blanks / sorting - common methods not applicable | Excel Discussion (Misc queries) | |||
Sorting by looking for blanks | Excel Discussion (Misc queries) | |||
How do I sort a list that contains blanks that I want to keep? | Excel Discussion (Misc queries) | |||
validation list blanks | Excel Worksheet Functions |