T()
Syntax. T(value)
Definition. This function checks whether an entry is text and returns the text value. If the entry is not a text value, the return value is empty.
Arguments
value (required). The expression (a number, text, a formula without an equal sign, a logical value, an error value, a reference, or a name) to check
Background. The T() function is provided for compatibility with other spreadsheet software. You do not normally need to use the T() function in formulas, because Excel converts values as required.
When using this function, keep in mind that numbers are not converted into numerals; instead, the result is an empty string. The same applies to logical values. Error values are converted into error values, not into text.
See Also
CELL(), ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
