Excel like a finance pro.
← The libraryPractice · 2 questions →
Information function
ISNONTEXT
Returns TRUE if a value is not text, blanks included.
Rarely usedDifficulty 1050 · CapableUsage rank #245 of 520
When to use it
TRUE for anything that is not text, including blanks, numbers, logicals, and errors.
The shape of it
- Syntax
=ISNONTEXT(value)
Worked examples
Number
=ISNONTEXT(123) → TRUE
A number.
Blank
=ISNONTEXT(A1) → TRUE
A1 is empty.
Empty text
=ISNONTEXT("") → FALSE
Empty text is still text.
Worth knowing
- Equivalent to NOT(ISTEXT(x)).
- Handy in validation: allow anything except text.
- Blanks count as non-text.
Where it goes wrong
- Errors return TRUE, which can be surprising.
- Rarely clearer than ISTEXT with NOT.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.