T

Microsoft Datasheet View

T

Returns the text referred to by value.

Syntax

T(value)

Value    is the value you want to test.

Remarks

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

  • You do not generally need to use the T function in a formula because values are generally converted as necessary.

Example

Formula Description (Result)
=T("Rainfall") Because the value is text, the text is returned (Rainfall)
=T(19) Because the value is a number, empty text is returned ()
=T(TRUE) Because the value is a logical value, empty text is returned ()