T Function in Excel: Syntax, Examples and Free Practice
T is an Excel Text function. Returns the text referred to by a value, or an empty string if it isn't text.
T syntax
=T(value)
Arguments
value: The value to evaluate
When to use T
T is used to clean up and reshape text data pulled from other systems before reporting on it.
Practice T online, free
Open the live Excel-style spreadsheet and try T yourself. No Excel install or sign-up needed to start.
Practice T now →More Text functions
Frequently asked questions
What does the T function do in Excel?
Returns the text referred to by a value, or an empty string if it isn't text.
What is the syntax of T in Excel?
The syntax is =T(value). value: The value to evaluate.
Where can I practice T online for free?
Open the free live spreadsheet on Cellgrids and try T yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Text functions · Excel case studies · Excel tutorials · Excel shortcuts