The Excel ISTEXT Function


Basic Description

The Excel Istext function tests if a supplied value is text, and if so, returns TRUE; Otherwise, the function returns FALSE.

The syntax of the function is:

ISTEXT( value )

Where the supplied 'value' argument can be supplied directly, or can be a value returned from a formula, or a reference to a cell containing a value.


Istext Function Examples

The spreadsheets below show several examples of the Excel Istext function.

 Formulas:
  A B
1 =ISTEXT( TRUE )  
2 =ISTEXT( "Peter" )  
3 =ISTEXT( 10/2 )  
4 =ISTEXT( B4 ) #VALUE!
5 =ISTEXT( B5 ) Peter
6 =ISTEXT( B6 )  
 Results:
  A B
1 FALSE  
2 TRUE  
3 FALSE  
4 FALSE #VALUE!
5 TRUE Peter
6 FALSE