Excel ISTEXT Function

HomeExcel Functions List (Top 100) Examples + Sample FileExcel ISTEXT Function (Example + Sample File)

What is EXCEL ISTEXT FUNCTION

The Excel ISTEXT Function is listed under Microsoft Excel's Information Functions category. It returns TRUE if the value supplied (or the value in the cell referred) is a text. In simple words, it only considers the text and ignores all other types of values.

How to use it

To learn how to use the ISTEXT function in Excel, you need to understand its syntax and arguments:

Syntax

ISTEXT(value)

Arguments

  • value: The cell reference or value for which you want to test.

Notes

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

Example

To master the ISTEXT function we need to try it out in an example and below is one which you can try out:

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

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.