Returns the text referred to by value.



Value     is the value you want to test.


  • If value is or refers to text, T returns value. If value does not refer to text, T returns "" (empty text).

  • You do not generally need to use the T function in a formula because values are generally converted as necessary.



Description (Result)


Because the value is text, the text is returned (Rainfall)


Because the value is a number, empty text is returned ()


Because the value is a logical value, empty text is returned ()

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!