T
Returns the text if the value is text, otherwise returns empty string.
T(value)Arguments
valueValue to test
=T("Hello")Returns text as-is
=T(123)Returns empty for numbers
=T(A1)Extracts only text
- •Rarely needed in modern Excel
- •Returns empty for non-text values
- •Useful for compatibility
- •Expecting T to convert a number into its text representation - it only passes through values that are already text, and returns an empty string for numbers, dates, and logical values
- •Using T where TEXT would actually be needed - T never formats or converts, it only tests whether the input is already text and returns it unchanged or blanks it out
- •Applying T to the result of a formula that sometimes returns text and sometimes returns a number, then being surprised when half the results come back as empty strings
NPerforms roughly the opposite of T - converts numbers and logical values to numbers, and returns 0 for text instead of the text itself.ISTEXTChecks whether a value is text and returns TRUE/FALSE, a more direct check than relying on T returning a non-empty string.VALUEConverts text that looks numeric into an actual number, the kind of conversion T deliberately does not attempt.What does T actually do?
It returns the value unchanged if it's already text, and returns an empty string for anything else - numbers, dates, logical values, and errors all become "".
Is T still useful in modern Excel?
Rarely - it was more relevant in older spreadsheets for compatibility with other programs. Most modern formulas use ISTEXT or TEXT instead, depending on whether you need a check or a conversion.
Why does T return an empty string for my formula result?
The underlying value is probably a number, date, or logical value rather than text - T only passes through genuine text values.
Need to translate a formula using T?
Use our translator to convert your complete formula