Skip to content
Google Sheets

ISTEXT function in Google Sheets

Checks whether a value is text.

=ISTEXT(value)

ISTEXT syntax and parameters

One argument, one required.

  • valueanyRequired

    The value to be verified as text. ISTEXT returns TRUE if this is a text value or a reference to a cell containing a text value and FALSE otherwise.

ISTEXT examples

Formulas you'll actually reuse.

  1. Flag an amount stored as text — it won't sum:

    =ISTEXT(C2)

    ResultFALSE

  2. How many amounts in the column are text:

    =SUMPRODUCT(--ISTEXT(C2:C200))

    Result3

ISTEXT in Excel

Same name — your formula ports as-is.

Try ISTEXT in the playground

Edit the example — nothing to install.

Preloaded with the ISTEXT formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.