<< Click to Display Table of Contents >> ISTEXT (is text?) |
Syntax:
ISTEXT(Cell)
Description:
This returns TRUE if the given cell contains text.
Example:
If A1 contains a fixed string or a calculation that returns a string, while C7 contains a number, the following applies:
ISTEXT(A1) returns TRUE
ISTEXT(C7) returns FALSE
Additional info:
ISNONTEXT is the counterpart of this function: It returns TRUE if there is no text string in the cell.
See also: