Exceljet

Quick, clean, and to the point

Excel ISTEXT Function

Excel ISTEXT function
Summary 

The Excel ISTEXT function returns TRUE when a cell contains a text value, and FALSE if the cell contains any other value. You can use the ISTEXT function to check if a cell contains a text value, or a numeric value entered as text.

Purpose 
Test for a text value
Return value 
A logical value (TRUE or FALSE)
Syntax 
=ISTEXT (value)
Arguments 
  • value - The value to check.
Version 
Usage notes 

The ISTEXT function returns TRUE when a cell contains a text value, and FALSE if the cell contains any other value, or is empty. You can use the ISTEXT function to check if a cell contains a text value, or a numeric value entered as text.

The ISTEXT function takes one argument, value, which can be a cell reference, a formula, or a hardcoded value. Typically, value is entered as a cell reference like A1. When value is text, the ISTEXT function will return TRUE. If value is any other value, ISTEXT will return FALSE.

Examples

The ISTEXT function returns TRUE if value is text:

=ISTEXT("apple") // returns TRUE
=ISTEXT(100) // returns FALSE

If cell A1 contains the number 100, ISTEXT returns FALSE:

=ISTEXT(A1) // returns FALSE

If a cell contains a formula, ISTEXT checks the result of the formula:

=ISTEXT(10 &" apples") // returns TRUE
=ISTEXT(2+2) // returns FALSE
=ISTEXT(A1&B1) // returns TRUE

Note: the ampersand (&) is the concatenation operator in Excel. When values are concatenated, the result is text.

Count text values

To count cells in a range that contain text, you can use the SUMPRODUCT function like this:

=SUMPRODUCT(--ISTEXT(range))

The double negative coerces the TRUE and FALSE results from ISTEXT into 1s and 0s and SUMPRODUCT sums the result.

Notes

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.