Rational
Check a cell for the text value
Description
The Excel ISTEXT function checks if a specified cell has a value in text format and returns “TRUE” when a cell contains a text value, and “FALSE” if not.
Syntax
=ISTEXT (value)
Parameters
value – Cell to check text value
Return Value
A Boolean value (TRUE or FALSE)
Key Notes
- The ISTEXT formula returns TRUE only if the value in the cell is in text format and even a numerical value entered as text and FALSE if the value is in any other format apart from text like number, date or currency.
- For example, =ISTEXT(B6) will return FALSE where B6 refer to a numerical value 100 and =ISTEXT(“100”) will return TRUE as the numerical value is in double quotation (“text format”).
- The ISTEXT formula is part of IS functions that return either TRUE or FALSE, depending on the argument they’re evaluating.
For example, =ISTEXT(B11) it return TRUE as in B11 contain space. so for space it is true.
Keep Reading Similar Functions:
ERROR.TYPE
The Excel ERROR.TYPE function returns an integer code of the corresponding error type or returns the #N/A if no error exists.
TYPE
The Excel TYPE function returns data type of reference cell or value of an argument. Example, =TYPE(“ABC”) return data type 2 (Text data format).
ISNONTEXT
The ISNONTEXT function checks if a specified cell has non-text value and returns “TRUE” when a cell has a non-text, and “FALSE” it contains a text value.
