How to use the T Function in Excel

Using the Excel T Function

Summary

The Excel T function returns text referred to by the value argument. This function is mostly for compatibility purposes with other spreadsheet programs and isn't commonly needed. The function can accept text values, empty strings (""), dates, and the logical values TRUE and FALSE.

Syntax

=T (value)

Syntax Breakdown

Value
Required. The value to be tested and returned as text.

Usage Notes

T returns text when given text for number, date, and logical values. Most users will not use the T function frequently as Excel automatically converts values when needed.