📎 This article includes 1 downloadable practice file ↓
In this article
T returns text unchanged and anything else as an empty string. Rarely needed alone, but tidy for mixed columns.
Syntax
=T(value)| Argument | What it means |
|---|---|
value |
Anything. |
Examples
Example 1
=T(A2)Shows labels and hides numbers in a mixed import column.
T in practice
Where you will use it
- Return text only, ignore numbers
- Clean mixed data
- Old Lotus-style formulas
Worked example
| shows where the result ends.
| Value | Formula | Result |
|---|---|---|
| Pune | =T(A2)&"|" | Pune| |
| 100 | =T(A3)&"|" | | |
| TRUE | =T(A4)&"|" | | |
Results calculated in Excel. | marks where the result ends: numbers and TRUE give empty text.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Expecting numbers to convert | Numbers become empty text |
| Rarely needed | Use IF(ISTEXT(...)) for clarity |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
Test formulas dynamically in our web formula laboratory or download the companion Excel workbook.
📎 Practice files for this article
- 📗Practice workbook: Text & cleaning24 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.⬇ XLSX · 35 KB
Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.
Stuck on a step? Ask a question and the AI answers using this article.