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.
Syntax: =T(value)
The T function syntax has the following arguments:
Example: Let’s look at some Excel T function examples and explore how to use the T function as a worksheet function in Microsoft Excel:
Syntax: =T(A2)
Result:
Based on the Excel spreadsheet above, the following T examples would return:
Syntax: =T(A3)
Result: T function in excel
Syntax: =T(A4)
Result: So Phuc.com
Syntax: =T(A5)
Result:
Syntax: =T(A6)
Result: So Phuc
Syntax: =T(A7)
Result: “”
Syntax: =T(A8)
Result: 13/4/2020
Syntax: =T(A9)
Result:
Note:
- The T function returns text when given a text value and an empty string (“”) for numbers, dates, and the logical values TRUE and FALSE.
- 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.
