T

Returns text values as text and others (e.g. numbers or logical values) as empty string.

Sample Usage

T(C5)

Syntax

T(value)

  • value - The value to be tested. 

 

Examples

T(C5) returns the text component of the value in cell C5.

Notes

If value is or refers to text, T returns value. If value does not refer to text, T returns "" (empty text).