Excel T Function

The Excel T function returns text when given a text value and an empty string ("") for numbers, dates, and the logical values TRUE and FALSE. You can use the T function to remove values that are not text.
- value - The value to return as text.
The Excel T function converts numbers, dates, and the logical values TRUE and FALSE into empty strings. Text values and errors are not converted and pass through unaffected. You can use the T function to remove values that are not text.
The T function takes one argument, value, which can be a cell reference, a formula result, or a hardcoded value.
Examples
The T function returns text when given a text value and an empty string ("") for numbers, dates, and the logical values TRUE and FALSE. For example:
In most cases, the T function is unnecessary, because Excel automatically converts values when needed. The T function is provided for compatibility with other spreadsheet programs.
Errors are not affected by the T function:
Notes
- The T function removes numeric values. The N function removes text values.
Download 100+ Important Excel Functions
Get over 100 Excel Functions you should know in one handy PDF.