ISNONTEXT
Here’s a little worksheet function that doesn’t get the credit it deserves. ISNONTEXT() works just like ISNUMBER() except that it returns TRUE for blank cells.

Daily posts of Excel tips…and other stuff
Here’s a little worksheet function that doesn’t get the credit it deserves. ISNONTEXT() works just like ISNUMBER() except that it returns TRUE for blank cells.
