Clearing cells containing zero-length strings (Excel 2000 and higher)

Topic

New Reply

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!

Any ideas?

Jeremy

Reply | Quote

Replies

Jeremy:

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.

Good Luck.

TomD

Reply | Quote