Checks whether a value is text and returns the text if it is, or an empty string if it is not.
Cú pháp
T(value)Đối số
valuebắt buộc
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.