Home/Formulas/Logic/ISTEXT
Logiceasy

ISTEXT()

Returns TRUE if a value is a text string.

Syntax
fx
=ISTEXT(value)
Arguments
ArgumentDescription
valueThe value to test.
Example
fx
=ISTEXT("hello")

Paste this into Google Sheets to run it. The live playground on this site covers 24 of the 61 functions, and ISTEXT isn't one of them yet.

Common pitfalls

  • Returns TRUE for the empty string "". Pair with LEN(x) > 0 if you need "non-empty text".
  • Numbers formatted as text (e.g. imported with leading apostrophe) return TRUE: so ISTEXT is the right test for "stored as string" rather than "looks like text".
Related formulas
ISNUMBER()
Returns TRUE if a value is a number; useful for guarding numeric expressions.
ISBLANK()
Returns TRUE if a cell is empty.
IFERROR()
Returns the first argument if it isn't an error; otherwise returns the second.
Used by
ISBLANK()
Returns TRUE if a cell is empty.
ISNUMBER()
Returns TRUE if a value is a number; useful for guarding numeric expressions.
More Logic formulas →Keyboard shortcuts for Sheets →