Excel like a finance pro.
← The libraryPractice · 2 questions →
Text function
T
Returns the value if it is text, otherwise an empty string.
Rarely usedDifficulty 1100 · ProficientUsage rank #251 of 520
When to use it
Returns the text if the value is text, otherwise an empty string. A filter that lets text through and blocks numbers.
The shape of it
- Syntax
=T(value)
Worked examples
Text
=T("hello") → hello
Text passes through.
Number
=T(123) → (empty)
A number becomes an empty string.
From a cell
=T(A2) → Widget
Only text from a cell.
Worth knowing
- Rarely needed; kept for compatibility with other spreadsheet programs.
- N is the numeric counterpart.
- IF(ISTEXT(x),x,"") is the same thing spelled out.
Where it goes wrong
- Returns empty text for TRUE and FALSE too.
- Easy to confuse with TEXT.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.