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 can be supplied to the function directly or as a reference to a cell containing a value.


Excel T Function Examples

The following spreadsheet shows several examples of the Excel T function. The format of the function is shown in the spreadsheet on the left and the result is shown in the spreadsheet on the right.

 Formulas:
Examples of use of the Excel T Function
 Results:
Excel T Function Results

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, not text values.