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, and FALSE if not. 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.
Usage notes 

Use the ISTEXT function to check if value is text. ISTEXT will return TRUE when value is text.

For example, =ISTEXT(A1) will return TRUE if A1 contains "apple".

Often, value is supplied as a cell address.

ISTEXT is part of a group of functions called the IS functions that return the logical values TRUE or FALSE.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.