ISTEXT

Returns TRUE if the value is text.

Sample Usage

ISTEXT("spreadsheet")
ISTEXT(C5)

Syntax

ISTEXT(value)

  • value - The value to be checked.

Examples

ISTEXT("spreadsheet") evaluates to TRUE.
ISTEXT(C5) checks the value contained in C5 for text.

Notes

  • Where the argument is an empty string ISTEXT(""), the function evaluates to TRUE while a reference to a blank cell will return FALSE.