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.

1text=T( A1 )
225=T( A2 )
3FALSE=T( A3 )

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.