Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Empty Cells!??
I checked, no space. No any sign of content since I used Len function to
check those cells and get 0 returned. Huyeote "BrianB" wrote in message om... Could contain the space character. Do Edit/Replace and put a space as the find character, leave the 'replace with' box blank, check "Find entire cells only". Regards BrianB ================================================== "Huyeote" wrote in message ... Hi, all, I'm working on an XL spreadsheet which lists debtors ageing. I found there are many cells obviously contain nothing in a data range. But when I use IsEmpty function or Specialcells(xlCellTypeBlanks) property to examine the cell, it does have something so that I can't use Areas property to work on discrete blocks of cells which I think contain values. Can anybody tell me what's possibly in those apparently empty cells and how to clear the contents? Thanks! Huyeote |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merging cells and eliminating spaces for empty cells | Excel Discussion (Misc queries) | |||
Randomly populating empty cells with other text cells | Excel Discussion (Misc queries) | |||
Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
When I SUM cells & 1 is empty I need the result to be empty not 0 | Excel Discussion (Misc queries) | |||
How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) |