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:
 AB
1=ISTEXT( TRUE ) 
2=ISTEXT( "Peter" ) 
3=ISTEXT( 10/2 ) 
4=ISTEXT( B4 )#VALUE!
5=ISTEXT( B5 )Peter
6=ISTEXT( B6 ) 
 Results:
 AB
1FALSE 
2TRUE 
3FALSE 
4FALSE#VALUE!
5TRUEPeter
6FALSE