Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Redditch, Worcestershire, England
    Posts
    233
    Thanks
    0
    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!

    Any ideas?

    Jeremy

  2. #2
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •