Name
ISTEXT
Synopsis
Use
ISTEXT to look at the specified
reference and return a logical value of TRUE
if
the cell contains text; otherwise, the function returns a value of
FALSE
.
To Calculate
=ISTEXT(Value
)
Example
Figure 20-3 illustrates the use of ISTEXT to make
sure the value in a cell is text and not a number, error value, or
logical value. If the cell contains anything other than text the
function returns a value of FALSE
.
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.