Excel T Function ( 6 examples)

Excel T Function

The Excel T Function is a text function, which returns text if users supply a text value and an empty string (“”) for numbers, logical value of TRUE and FALSE (because TRUE means 1 and FALSE means 2–the numbers), and dates. Users use the Excel T function to delete values, which are not text.

In this section:

---

1. Syntax if T Function
2. Use of T Function to return text
3. Return empty text () if the value is number
4. Return empty text () if the value is a logical one
5. T Function returns empty text () if the value is a date
6. Practical use of T Function

---

1. Syntax of T Function:

T(value)

where:

• Value: The value or the reference to cell containing value. [Required.]

2. Use of T Function to return text:

T Function is used to return text, and the formula is =T(C6), which returns text if they reference is not numbers, dates, and logical value.

3. Return empty text () if the value is number:

If the value or the reference to cell containing value is number, the T() function returns empty ().

4. Return empty text () if the value is a logical one:

If the value or the reference to cell containing value is logical value or TRUE or FALSE, the T() function returns empty ().

5. T Function returns empty text () if the value is a date:

If the value or the reference to cell containing value is date, the T() function returns empty ().

6. Practical use of T Function:

To join first and last name with &, for missing or zero users should use the T Function to convert the missing or zero to nothing. The formula is =T(C6)&” “&T(D6), which combines the first and last name after converting the zeroes to nothing.

More related readings:

1. MS Office post on T Function
2. Extract first Name in excel (3 practical examples)
3. Extract Middle names (3 practical examples)
4. Excel ARRAYTOTEXT Function
5. Excel CLEAN Function with practical examples
6. Excel CONCAT Function to join text
7. Excel REPLACE Function to replace text
8. Excel TRIM Function with Practical Examples