Checks whether a value is text and returns the text if it is, or an empty string if it is not.
Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes 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")Résultat : Hello
Since 'Hello' is a text string, the function returns it.
=T(123)Résultat :
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.