The ISTEXT Excel function is an Information formula that returns TRUE if the input value is a text string, and FALSE otherwise. You can test the result of a formula or value of a cell using this function. This formula can be especially useful in error handling, organizing data, and troubleshooting.  In this guide, we’re going to show you how to use the ISTEXT Excel function and also go over some tips and error handling methods.


Supported versions

  • All Excel versions

ISTEXT Excel Function Syntax

ISTEXT(value)


Arguments

value The value or reference you want to test.

ISTEXT Excel Function Sample Use Case

The ISTEXT function, just like the other IS… functions, only requires a single argument as an input. A common use case for this function is testing the value of a cell or outcome of a formula. The function returns a TRUE logical value, if the value argument is a text string, and FALSE if it’s not.

=ISTEXT(“a string”) returns TRUE

=ISTEXT(100) returns TRUE

Download Workbook


Tips

  • You can use the ISTEXT function as a logical test inside an IF function.
    =IF(ISTEXT(A1),”A text”,”Non-text”)
  • The function returns FALSE for empty cells. On the other hand, if a formula returns an empty string (“”), the cell will look blank in the Excel interface, but the ISTEXT function will return TRUE in this case, as Excel considers a space to be a non-empty character.
  • IFERROR function can return a specific value in the event of an error.
  • Below is a list of other IS… functions:
    • ISBLANK to test blank cells
    • ISERR to test error values except #N/A
    • ISERROR to test all error values
    • ISNA to test #N/A error value specifically
    • ISNUMBER to test numbers
    • ISNONTEXT to test any item that is not a text
    • ISREF to test a reference
    • ISEVEN to test even numbers
    • ISODD to test odd numbers