How to use the 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. 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:

Excel T Function - How to use the Excel T function

Syntax:  =T(A2)

Result:

Excel T - How to use the Excel T function

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.
READ:  How to use the Excel AND function

Add a Comment

Your email address will not be published. Required fields are marked *