The ISTEXT function checks if a value is of type text, returning the logical value True in positive case or the logical value False in negative case.
ISTEXT(
value
)
- value: Value to evaluate.
The ISTEXT function returns a Boolean.
Both a blank space and an empty text string ("") are considered texts. A Blank, no.
The result of this function matches the negation of the result of the ISNONTEXT function.
This simple example checks whether or not "a" is a text:
This second example checks whether or not a Boolean is of type text:
Now we check whether or not a blank space is of type text:
Now it is checked whether an empty text string is or is not considered text:
This example checks whether or not a Blank is a text string: