ISTEXT in Google Sheets: Check Text, Empty Strings and Codes

• 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 ISTEXT reference. Documentation and independent models, with no native Google Sheets execution or wider client certification.

=ISTEXT(value)

The required value may be text, another value, a reference or a formula expression. A TRUE result classifies the type; it does not establish that a code is valid, a name is complete or a description has visible characters.

For example, the string "0042" is text even though its characters are digits. Converting it to the number 42 is a separate decision that discards its leading zeros.

Create these cells in A2:A9 and fill =ISTEXT(A2) down B2:B9.

Four cells contain text. The blank-looking A5 and A7 still count as text; A6 does not. The displayed error in A9 is an actual error value rather than the text spelling of an error. ="#N/A" would instead create text.

Google’s companion ISNONTEXT reference explicitly includes whitespace and nonprinting characters as text. A screen that appears empty is therefore insufficient evidence that the cell is empty.

To accept text with at least one character, use:

=IF(ISTEXT(A2),LEN(A2)>0,FALSE)

Filled down, this accepts A2, A4 and A7. Empty text fails, but the single space has length one and passes. For a policy that rejects ordinary space-only text, use:

=IF(ISTEXT(A2),LEN(TRIM(A2))>0,FALSE)

Only A2 and A4 now pass. This is an ordinary-space cleanup rule, not a guarantee that every Unicode whitespace or hidden character is removed. A function can correctly classify a text value while that value fails a later completeness rule.

Put ="00042" in D2. Its text length is 5, and =ISTEXT(D2) is TRUE. For this simple digit string, =VALUE(D2) yields number 42; =ISTEXT(VALUE(D2)) is FALSE.

If D2 is a stock identifier, those zeros may be part of its meaning. If it is a quantity field, an explicit parse may be appropriate. Retain the original column while deciding the conversion policy rather than treating all text as damaged data.

A number displayed with leading zeros through formatting remains a different stored representation. ISTEXT asks about the supplied value, not the appearance of a formatted cell.

Use this formula on the original input column:

=IF(ISTEXT(A2),"Text",IF(ISNUMBER(A2),"Number","Other"))

The labels are Text, Number, Text, Text, Other, Text, Other, Other. The “Other” group deliberately contains several different types. If a numeric quantity is required, ISNUMBER is the appropriate type check; NOT(ISTEXT(...)) would also accept blanks, Booleans and errors.

For a formula returning explicit "", the text rule above is documented. This guide does not equate that string with every possible blank/null result, such as a function whose optional fallback was omitted. Test those separately rather than carrying a blanket “all formulas count as text” assumption into an import audit.

ISBLANK answers an empty-cell question, and LEN measures text length. A formula can return text, a number or an error; ISTEXT classifies its result rather than whether the cell contains a formula. Array expansion, external imports and a full special-type matrix remain outside these scalar controls.

• Google ISTEXT 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.