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.
