ISNONTEXT in Google Sheets: Detect Nontext Without Accepting Bad Data

• Introduced: first introduction date is not established by the official history reviewed; no desktop release number is inferred.
• Availability: documented in the rolling Google Sheets service; these examples use the web worksheet workflow.
• Checked: October 14, 2026; official ISNONTEXT reference. Documentation and independent models, with no native Google Sheets execution or wider client certification.

=ISNONTEXT(value)

The required value can be supplied directly or through a reference. Google documents this function as the logical equivalent of NOT(ISTEXT(value)). Numeric-looking text, whitespace and nonprinting text remain text rather than being converted into numbers by the test.

Set up A2:A9 as follows. Fill =ISNONTEXT(A2) in B2 and =ISNUMBER(A2) in C2.

There are five nontext results but only two numeric results. The difference consists of a Boolean, an empty cell and an actual error. Replacing ISNUMBER with ISNONTEXT in a data-validation rule would incorrectly include those three cases.

A7’s displayed #N/A is not the same input as the string created by ="#N/A". The latter is text and produces FALSE from ISNONTEXT.

Use this row-level report formula:

=IF(ISTEXT(A2),"Text",IF(ISNUMBER(A2),"Number",IF(ISBLANK(A2),"Empty",IF(ISLOGICAL(A2),"Logical","Other"))))

Filled down, it returns Number, Text, Logical, Empty, Text, Other, Text, Number. The error is deliberately in “Other”; add a separately documented ISERROR branch if your report needs its own error label.

The order of these explicit tests is part of the report design. A broad nontext branch placed first would prevent several of the more informative categories from ever being reached.

For a field allowing any nonnegative numeric value:

=IF(ISNUMBER(A2),A2>=0,FALSE)

Only A2 and A9 pass in the original table. The numeric string 24 is not accepted until you deliberately parse it. Negative -6 in a separate cell is nontext but fails the nonnegative rule.

If the field must also contain whole units, extend the numeric branch with an integer check such as A2=TRUNC(A2). Conversely, if fractional measurements are valid, rejecting them would unnecessarily change the data policy. The type function cannot decide that policy for you.

In D2 put =NOT(ISTEXT(A2)) and fill down. Its values match column B for all eight controls. Counting TRUE results in the two complementary type helpers gives five nontext and three text values, totaling eight cells.

That arithmetic does not describe occupancy: a genuinely empty cell is included on the nontext side. Nor does it describe validity: the error contributes to that same side. State the classification question before presenting the counts as a quality measure.

With A6 still ="", =ISNONTEXT(A6) is FALSE. A8 contains one ordinary space and is also FALSE. Replacing A6 with a genuinely empty cell makes its result TRUE; merely making its display look blank would not establish that it became empty.

These controls use explicit empty strings and actually empty cells. A blank/null result from an omitted fallback has not been certified as identical to either control. See IFERROR for the separately scoped distinction.

Use ISTEXT to ask the complementary question, ISNUMBER for numeric type, and ISBLANK for physical emptiness. No native array, special-cell-type or cross-client behavior matrix is implied by this scalar report.

• Google ISNONTEXT reference.
• Editorial testing standards.

Examples use fictional inputs, English function names and comma argument separators. Expected outputs are independently modeled from the cited rules, not native Sheets captures. Check the spreadsheet locale when reproducing punctuation-sensitive formulas.