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.
Bookmarks