Navigation:  Formulas and functions > Functions from A to Z > T (convert value into text string)

Syntax:

T(Value)

Description:

This converts a value into a text string.

The specified value must be a text string, otherwise the function returns an empty text string.

Note:

This function was retained only for compatibility with older spreadsheet applications. It is no longer commonly used, as current spreadsheet applications (including Calculate) automatically convert values into text strings if necessary.

Example:

T("Text") returns text

T("42") returns 42

T(42) returns an empty text string

T(TRUE) returns an empty text string

See also:

N, VALUE, TEXT