Returns the Boolean value “True” if the value passed to the function is text else returns “False”.
= ISTEXT(value)
Value |
A value which has to be checked. The value can be specified as a decimal value (e.g., 37.48), as a string (“123”), as a Date (“1/28/2010”), or as the value of a variable (e.g, ShippedDate). |
Boolean
Example |
Returns |
= ISTEXT(30) |
False |
= ISTEXT(“30”) |
True |
= ISTEXT(“abcd”) |
True |
= ISTEXT(ShippedDate) |
False if the value of date is not of type text else returns True. |