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.