Syntax
ISNONTEXT(value)
| Parameter | Description |
|---|---|
| value | Parameter of the ISNONTEXT function. |
Examples
Filter for non-text
Formula
=ISNONTEXT(A1)
Returns TRUE if A1 contains a number, boolean, error, or is blank. Returns FALSE only if A1 contains actual text.
Validate numeric column
Formula
=IF(ISNONTEXT(B2), "OK", "Contains text")
Flags cells that contain text in a column that should be numeric. Note that blanks also return "OK" with this approach.
Count non-text entries
Formula
=SUMPRODUCT(ISNONTEXT(A1:A100)*1)
Counts all cells in A1:A100 that are not text — including blanks, numbers, booleans, and errors.
Common Errors
#VALUE!
ISNONTEXT never produces errors — it always returns TRUE or FALSE.
Tips
Blanks return TRUE
Empty cells are "not text," so ISNONTEXT returns TRUE for them. If you need to check for "is a number" specifically, use ISNUMBER instead.
Exact inverse of ISTEXT
=ISNONTEXT(A1) always equals =NOT(ISTEXT(A1)). Use whichever reads more naturally in your formula.
Rare in practice
ISNUMBER and ISTEXT are used far more often. ISNONTEXT is mainly useful when you want to accept any non-text value (numbers, booleans, blanks) uniformly.
Try ISNONTEXT in Viztab
Import your data and use ISNONTEXT with 370+ other formulas. No signup required.
Open Viztab