Syntax: | ISSTRING(X) |
ISTEXT(X) |
X = a numeric value
ISSTRING returns 1 if X is a string value, otherwise 0. Blank cells are considered numeric.
ISTEXT is a synonym for ISSTRING.
Examples:
ISSTRING(C10) = 1, where C10 = ``Total''
ISTEXT(D10) = 0, where D10 = $1000.00
ISTEXT(A1)= 0, where A1 is blank
Excel function: ISTEXT