Checks whether a value is text and returns the text if it is, or an empty string if it is not.
Syntax
T(value)Argument
valueobligatoriskt
The value you want to test.
The T function is used to return the value if it is text, or an empty string if the value is not text. It is often used in formulas to ensure that a cell contains text, as it ignores numbers, logical values, and error values.
=T("Hello")→HelloSince 'Hello' is a text string, the function returns it.
=T(123)→Since 123 is a number, the function returns an empty string.
Select the cell
Click on the cell where you want to display the result.
Enter the formula
Type =T(value) and replace 'value' with the cell reference or text you want to check.
It returns an empty string when the input is not text, such as a number, date, or error value.