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 :

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.

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.