The ISTEXT function checks if the value is text.
Returns TRUE if it is and FALSE if not.
This function can be useful for validating data and managing conditions in formulas.
Syntax
ISTEXT(value)
Argument |
Description |
Permitted values |
|---|---|---|
value |
Value that is checked for being a text |
Any value (number, text, formula, cell reference, and so forth) |
Examples of use
Checking the value in a cell
=ISTEXT(A1)
If cell A1 contains a text, the function returns TRUE. If A1 contains a number or is empty, FALSE will be returned.
Checking the constant
=ISTEXT("1234")
In this case, the function will return TRUE, since the string “1234” is text, even though it looks like a number.
Use in a conditional formula
=IF(ISTEXT(B1), "This is text", "This is not text")
If the value in cell B1 is text, the function will return “This is text”; otherwise, it will return “This is not text.”
Notes
–The ISTEXT function returns TRUE only for text values.
–For numbers, dates, logical values, errors, and other data types, FALSE is returned.
–This function is often used in conjunction with other function for checking types: ISNUMBER, ISLOGICAL, ISERROR.