It’s time for you guys to learn Excel Function. Today, we are going to learn a simple and new one, that’s T function.

Syntax

=T(value)

Purpose: Filter text value only

So, the T function aims to test whether the provided value is a text type, and if so, returns the text; otherwise, you will get a blank cell.

Let’s take an example.

Cell B3 shows the text in cell A3.

Now, let’s make a distinction between the values in the yellow box.

[123456] is number, so cell B4 shows nothing.

[“123456”] Numbers enclosed in double quotation marks are text types. So cell B5 shows “123456”

[123456] in cell A6. The green triangle in the upper left corner of the cell indicates that the cell is of text type.

Actually, we do not usually use the T function. Anyway, multi-skills are not pressured. See you next time.