Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Dec 2001
    Location
    Philadelphia, Pennsylvania, USA
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    blank cells which aren't! (XP)

    Edited by HansV to provide link to post. See <!help=19>Help 19<!/help>

    This question relates a <post:=136,831>post 136,831</post:> from 2002 in this forum which describes a problem with null values in a spreadsheet created by importing data from Access.

    I have the same situation. For these cells, why does the function ISBLANK return a value of FALSE, yet COUNTBLANK return a value of 1 rather than 0?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: blank cells which aren't! (XP)

    Who knows? I'd just run one of the macros provided in the thread you referred to to get rid of those values.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: blank cells which aren't! (XP)

    Hi there

    This was at one time the biggest pain, that and null dtae/time values in SQL (another story <img src=/S/wink.gif border=0 alt=wink width=15 height=15>)

    I have attached a workbook for you to look at. The contents of B47 is a single inverted comma...you can see that returns zero length and it counts as blank although we can definitely see it in the cell. I have had exports that carry over chr(10) and chr(13) line feeds and carriage return characters which are not visible but shake up your data validation something chronic. Infuriating but it is best to go with Hans's advice and used the macro's mentioned and use them as your routine data cleansing exercise unless you can specifically find the miscreant character
    Jerry

Posting Permissions

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