How to Use T Function

The T function is to return the text value. When it is not text, the result returns a blank.

Formula:

=T(text)

Explanations:

The text is required, the text you want to test.

Cautions:

When the value does not refer to text, the T function returns a blank.

Example: Test the text value in cell A2 to A5.

= T(A2), returns value "ABC";
= T(A3), returns value "123 ABC";
= T(A4), returns blank when it is a number;
= T(A5), returns blank when it is a date.

Download: T Function

Leave a Reply