Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Blank Cells Have Data ?
Hi
I run Excel 2K I have a spreadsheet that was downloaded from a mainframe source. (the source allows saving data in an Excel format) There is approx 16,000 rows off data and 15 columns wide. Most of the cells are showing as empty. However there is actually data in them as when I use the counta formula it counts the blank cells as well. If i put the curser in the blank cells and press delete the counta formula I am using then displays the correct answer. I need to be able to highlight the entire database and delete whatever it is in the blanks cells without deleteing that data that is visible. any ideas? Thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Blank Cells Have Data ?
If the "empty" cells contain unseen space characters, this macro will remove
them: http://www.mvps.org/dmcritchie/excel/join.htm#trimall The macro also removes other whitespace characters so you might want to try that first on a copy of your file. -- Biff Microsoft Excel MVP "John Calder" wrote in message ... Hi I run Excel 2K I have a spreadsheet that was downloaded from a mainframe source. (the source allows saving data in an Excel format) There is approx 16,000 rows off data and 15 columns wide. Most of the cells are showing as empty. However there is actually data in them as when I use the counta formula it counts the blank cells as well. If i put the curser in the blank cells and press delete the counta formula I am using then displays the correct answer. I need to be able to highlight the entire database and delete whatever it is in the blanks cells without deleteing that data that is visible. any ideas? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to average data if in cells, but ignore blank cells. | Excel Worksheet Functions | |||
cells blank despite having data in them? | Excel Discussion (Misc queries) | |||
Fill blank cells with cells above data | Excel Worksheet Functions | |||
Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
Why does linked data from blank cells become a zero? | Excel Discussion (Misc queries) |