The Excel T Function

Basic Description

The Excel T function tests if a supplied value is text and if so, returns the supplied text; Otherwise, the function returns an empty text string.

The format of the function is:

T( value )

Where the value argument is the value that you want to test.


Excel T Function Examples

The following spreadsheets show three simple examples of the Excel T function.

 Formulas:
 AB
1text=T( A1 )
225=T( A2 )
3FALSE=T( A3 )
 Results:
 AB
1texttext
225 
3FALSE 

Note that, in cells B2 and B3 of the above example spreadsheet, the T function returns an empty string. This is because the supplied arguments are the number 25 and the logical value FALSE, which are not text values.


Further information and examples of the Excel T function are provided on the Microsoft Office website.