Excel Text Functions

Description
NOTES
  • T is commonly used to ensure a value is treated strictly as text.
  • Numeric values, logical values, errors, and non-text references return an empty string.
  • T does not perform any text conversion—it only extracts text values.
  • Useful in formulas where text-only input is required to avoid calculation errors.
Syntax
Copied!
=T(value)
SAMPLE-1
EXAMPLE 1.1
Copied!
=T(A2)
RELATED POST

Join our newsletter to stay up to date

Click the button below to sign up for our advanced platform. Get started now and see the benefits for yourself.