Checks whether a value is text and returns the text if it is, or an empty string if it is not.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
T(value)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")Result: Hello
Since 'Hello' is a text string, the function returns it.
=T(123)Result:
Since 123 is a number, the function returns an empty string.
It returns an empty string when the input is not text, such as a number, date, or error value.