Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing blanks from a spreadsheet
I created a huge data analysis file that consists of 50 by 214 cells.
According to my formula's, it will only show data if a lot of demands are met. In reality, this means, about 15 to 20 of them have data, and the others are blank. I now want to quickly remove all the blanks. However, Go ToSpecialblanks, doesn't work, because for some reason, Excel doesn't consider my blanks to be blank, even after I copied the values to another worksheet, and am certain that these cells are actually blank and empty. Soooo, do any of you experts know a solution for this problem? Or another way to quickly gather these appx. 20 cells that do have data in them in one column? Without blanks? I'd hate to do that manually. Thank you in advance. I'll be in bed really soon, cause it is terribly late in Europe, but I'll be back first thing in the morning to check your ideas, and provide feedback or add info I forgot to post right away... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing blanks from a spreadsheet
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet shortcuts not working | Setting up and Configuration of Excel | |||
Spreadsheet Security | Excel Discussion (Misc queries) | |||
CountIF Function On Linked Spreadsheet | Excel Discussion (Misc queries) | |||
Removing non text characters from spreadsheet | Excel Discussion (Misc queries) | |||
Spreadsheet merging problems | Excel Worksheet Functions |