Results 1 to 2 of 2
2012-03-19, 14:36 #1
- Join Date
- Apr 2002
- Redditch, Worcestershire, England
- Thanked 22 Times in 21 Posts
Clearing cells containing zero-length strings (Excel 2000 and higher)
I have a block of data created by a report from an external SAP system, and within that block are certain cells containing zero-length strings.
I need to clear those cells ready for import into another system. I know that I can do this with a macro, by writing something like this:
if cell.value = "" then cell.ClearContents
but is there a method via the user interface that does not rely on macros?
Trying a Goto, special, blank cells doesn't work because the cells aren't truly blank to begin with!
2012-03-20, 12:04 #2
- Join Date
- Nov 2002
- New York, New York, USA
- Thanked 19 Times in 19 Posts
If the data in the cells not having "zero length strings" are all formulas and/or numbers you could use GO TO Special - Select Constants - Select "Text" only.
This should select only the cells with zero length strings since they are not blank and they are not formulas / numbers.
If the other data is Text the above will not work.