Test for a text value

Sponsored Link


Test for a text value

Return value 

A logical value (TRUE or FALSE)


=ISTEXT (value)


  • value - The value to check.

Usage notes 

Use the ISTEXT function to check if value is text. ISTEXT will return TRUE when value is text.

For example, =ISTEXT(A1) will return TRUE if A1 contains "apple".

Often, value is supplied as a cell address.

ISTEXT is part of a group of functions called the IS functions that return the logical values TRUE or FALSE.

Sponsored Link

0 votes. 0 / 5