Excel ISTEXT Function

The ‘ISTEXT’ formula in Excel is used to ascertain whether or not a specified input cell contains a text value. It returns TRUE if the specified cell contains text, or FALSE if it does not. For example, =ISTEXT(“Test”) would return TRUE, whereas =ISTEXT(“12”) would return FALSE.

The ISNUMBER function is part of a larger group of IS functions that all return logical values (i.e. TRUE or FALSE). The other IS functions are ISODD, ISEVEN, ISBLANK and ISNUMBER.

Syntax

=ISTEXT(value)

Arguments

Value – input cell to check. Note that only individual cells can be specified.

Function category

Information

Returns

Returns a logical value i.e. TRUE if the specified cell contains a text value or FALSE if it does not.

Download Excel File

 Example of ISTEXT function
error

Comments (No)

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.