How to Use Excel ISTEXT Function

how to use excel istext function

Quick Intro

Excel ISTEXT Function is useful when you want to check if a value is a text string. It will return TRUE if a value is a text, else FALSE.

Even if a number is formatted as a text it will return TRUE. It’s useful to check outcomes for formulas or to check value type from a cell.

Syntax

ISTEXT(value)

  • value A cell reference or a value for which you want to test.

Additional Information for Excel ISTEXT Function

  • Any number enclosed in double quotation marks will be treated as a text.

Example

In the below example, I have used ISTEXT with IF function to create a nesting formula to deliver an alert message if a user enters an invalid name other than a text.

Examples For Excel ISTEXT Function

Sample File

download sample file to learn more about this tips

What’s Next?

To learn more about Excel ISTEXT Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have ISNONTEXT function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.