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.
Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].
Leave a comment