Contents
Welcome to another marathon weekend 30 Excel functions in 30 days. You are probably already exhausted working in Excel this week and a complex example for a function TRANSPOSE (TRANSP), which we analyzed yesterday. Saturday is great for an invigorating cup of tea!
On the 14th day of the marathon, we will devote the study of the function T (T), one of the least useful compared to other features. It checks if the value is text. There are other functions in Excel that can do this kind of check. So do we really need a function T (T)?
To make a decision, let’s see the information and examples of using the function T (T). If you have additional information or examples on working with it, please share them in the comments.
Function 14: T
Function T (T) returns text if the value in the cell is text, or an empty string if not text.
How can you use the T(T) function?
Function T (T) has a very limited range of tasks and can be replaced by another function, for example, ISTEXT (ETEXT). you can use T (T) to:
- Return text if value is text.
- Return an empty string if the value is not text.
Syntax T (T)
Function T (T) has this syntax:
T(value)
Т(значение)
- value (value) – any value, formula, or cell reference.
Traps T (T)
Function T (T) will report an error if the cell value is an error. ISTEXT (ETEXT) returns FALSE in the same situation.
Example 1: Checking if a value is text
I can’t imagine a situation where a function T (T) would be preferable to the function ISTEXT (ETEXT). Let’s compare both functions point by point and see what happens.
If the cell value is text, the function T (T) will return that text. In the picture below, the function T (T) is used in cell C4 to check the value in cell B4.
=T(B4)
The content of B4 looks like a number, but it is preceded by an apostrophe, so it is text. Function T (T) will return the string “1234”. In column D, the function ISTEXT (ETEXT) also checks the value of cell B4, but returns TRUE.
=ISTEXT(B4)
=ЕТЕКСТ(B4)
If the value is a number, as in cell B3 in the following figure, the function T (T) will return an empty string. If we use the function ISTEXT (ETEXT), the result is FALSE.
If the cell contains an error value, then the function T (T) will return an error message, and ISTEXT (ETEXT) will return FALSE.
