+ Reply to Thread
Results 1 to 3 of 3

Blank cells read as text

  1. #1
    Registered User
    Join Date
    06-08-2008
    Location
    Boston Massachusetts
    MS-Off Ver
    Excel for Office 365
    Posts
    28

    Blank cells read as text

    I have blanks that are being read as text (e.g., if I do a counta function, it counts the blank cells as text.
    Can I convert these blanks so they are not read as text?

    These blanks originated by converting the results of this formula:

    =IF(ISNUMBER(C6),C6,IF(LEFT(C6,1)="<",C6,IF(RIGHT(C6,1)="J",REPLACE(C6,LEN(C6),1,""),"")))

    to values (Paste Special Values).


    The results displayed as blanks were referenced to a cell that had "--" in it, thus did not satisfy any of the conditions i the above formula.
    Last edited by TimB; 05-03-2011 at 03:03 PM. Reason: I said the cells were read as numbers, actually read as text.

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Blank cells read as text

    Do the referenced cells actually contain "--" or are they zeros that are formatted to display as "--"?

    EDITED TO INCLUDE THIS...
    If you are trying to count text cells, but skip formula_blanks....
    this formula counts text cells that have at least one character:
    Please Login or Register  to view this content.

    Does that help?
    Last edited by Ron Coderre; 05-03-2011 at 03:14 PM.
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    06-08-2008
    Location
    Boston Massachusetts
    MS-Off Ver
    Excel for Office 365
    Posts
    28

    Re: Blank cells read as text

    The reference cells contain --, with no apostrophe

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1