Returns the text referred to by value.
Syntax
T(value)
Value is the value you want to test. If value is or refers to text, T returns value. If value does not refer to text, T returns ""(empty text).
Remarks
You do not generally need to use the T function in a formula because Microsoft Excel automatically converts values as necessary. This function is provided for compatibility with other spreadsheet programs.
Examples
If B1 contains the text "Rainfall":
T(B1) equals "Rainfall"
If B2 contains the number 19:
T(B2) equals ""
T("True") equals "True"
T(TRUE) equals ""