Summary
The Excel ISTEXT function returns TRUE when a cell contains a text, and FALSE if not.
Purpose
Test for a text value
Return value
A logical value (TRUE or FALSE)
Syntax
=ISTEXT (value)
Arguments
- 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.
