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.

Examples of use of the Excel T Function
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.

Return to the Excel Text Functions Page

Return to the List of All Built-In Excel Functions