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.
Leave a Reply