Exceljet

Quick, clean, and to the point

Excel T Function

Excel T function
Summary 

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. The T function is provided for compatibility with other spreadsheet programs and is generally not required.

Purpose 
Filter text values only
Return value 
Value as text when text
Syntax 
=T (value)
Arguments 
  • value - The value to return as text.
Usage notes 

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:

=T("apple") // returns "apple"
=T("NASA") // returns "NASA"
=T(100) // returns ""
=T(FALSE) // returns ""

In most cases, using the T function is unnecessary, because Excel automatically converts values when needed. The T function is provided for compatibility with other spreadsheet programs.

Related functions 
Excel N function
Excel N Function

The Excel N function returns a number when given a value. The N function can be used to convert TRUE and FALSE to 1 and 0 respectively. When given a text value, the N function returns zero.

500 Formula Examples, thoughtfully explained.