Text

T Function in Excel

Returns the text referred to by value.

Syntax

  • =T(value)

Arguments

  • value (required): Value to test

Examples

  • =T("Hello") - Return text - Result: Hello
  • =T(123) - Return empty for number

Excel T function documentation

  • T returns text when the value is text, and returns an empty string for numbers, dates, and logical values.
  • Syntax: =T(value). Useful in templates that must pass through text-only content.
  • Use T to avoid accidental numeric leakage into text concatenation pipelines.
  • Text function category: [/categories/text/](/categories/text/).

T syntax and return behavior

  • value can be a cell reference, formula result, or literal input.
  • If value is text, T returns that exact text unchanged.
  • If value is numeric or date serial, T returns "".
  • Errors in value are returned as errors, which helps debugging.

Step-by-step: protect text-only notes column

  • Step 1 - Keep mixed content in A2:A200 where only notes should flow forward.
  • Step 2 - In B2 use =T(A2).
  • Step 3 - Copy down and use column B in narrative exports.
  • Step 4 - Combine with IF for defaults when T returns empty text.

T vs TEXT vs ISTEXT

  • T filters to text-only outputs without formatting conversions.
  • TEXT formats numbers into strings using format codes.
  • ISTEXT checks type as TRUE/FALSE, while T returns usable text output.
  • Date construction still belongs to [DATE](/functions/date/) formulas.

Worked examples to copy

  • Pass text only: =T(A2).
  • Default note: =IF(T(A2)="","No note",T(A2)).
  • Concatenate safely: =T(A2)&" - "&T(B2).
  • Error visibility: =T(1/0) returns #DIV/0! for debugging.

People also ask

  • Why does T return blank for dates? - Dates are numeric serials in Excel.
  • T vs TEXT function? - T checks type; TEXT converts numbers to formatted strings.
  • Can T clean non-text values? - It filters them out by returning empty text.
  • Should I use T in dashboards? - Helpful when you need strict text pipelines.

Common errors

  • Returns empty string for non-text

Use cases

  • Type checking
  • Compatibility
  • Data cleaning

Frequently asked questions

  • What is the T function in Excel? T returns the text referred to by value. The syntax is =T(value). Typical use cases include type checking, compatibility, data cleaning.
  • How do I use the T function? To use T, type =T( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
  • Can T handle different text formats? Yes, T can work with various text formats including strings, cell references containing text, and text values returned by other functions. It processes text according to its specific functionality.
  • Why is T not working in my Excel? Common issues with T include Returns empty string for non-text. Start by checking the syntax =T(value), then verify each referenced cell or range.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.

When to use T

  • Type checking — common Text scenario for T.
  • Compatibility — common Text scenario for T.
  • Data cleaning — common Text scenario for T.

T in the Text category

  • Browse all Text functions at /categories/text/ for related formulas.
  • T syntax: =T(value)
  • value (required): Value to test
  • Confirm T arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.

Formula checklist before you copy down

  • Confirm T arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.
  • If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
  • Spot-check three known input rows manually against expected output.

Related Excel functions

  • N (/functions/n/): Returns a value converted to a number.
  • VALUE (/functions/value/): Converts a text string that represents a number to a number.
  • TEXT (/functions/text-function/): Converts a value to text in a specified number format.

Errors to watch for

  • Returns empty string for non-text — review causes on linked error pages in the directory.

Copy-paste audit workflow

  • Enter T on three test rows with known expected output documented on a QA tab.
  • Fill down only after absolute references are locked on lookup tables and rate tables.
  • Compare against manual calculation or a calculator for financial and statistical functions.
  • Search this directory for comparison guides when choosing between similar functions in the same category.

T worked examples to copy

  • =T("Hello") — Return text. Expected result: Hello.
  • =T(123) — Return empty for number.

T reference summary for crawlers and offline review

  • T belongs to the Text category in Excel. Returns the text referred to by value.
  • Full syntax: =T(value). Open /functions/t/ for parameters, FAQs, and related pages.
  • Common mistakes: Returns empty string for non-text
  • Pair this function with comparison guides when another Excel formula might fit the same task better.
  • Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.