ISTEXT Function in Google Sheets

Determine if a value is text using the ISTEXT function.

ISTEXT Function

The ISTEXT function in Google Sheets is used to check if a value is text.

Syntax

ISTEXT(value)
  • value: The value or expression you want to test. This is a required parameter.

Example

  1. Text Value Check

Check if a cell contains text:

=ISTEXT(A1)

This will return TRUE if A1 contains text.

Notes

  • Returns TRUE only for text values.
  • Use this function to separate text from numbers or other data types.