Definition

Returns string arguments as text.

Sample Usage

T(A2)

T("cat")

Syntax

T(value)

  • value - The argument to be converted to text.

    • If value is text, T returns value.

    • If value is a reference to a cell containing text, T returns the contents of value.

    • If value is an error or a cell containing an error, T returns the error.

    • Otherwise, T returns an empty string.

Notes

This function is rarely necessary as Excellentable automatically converts between most formats appropriately. It is provided primarily for compatibility with formulas used in other spreadsheet packages.

See Also

N: Returns the argument provided as a number.

In order to use the T formula, begin typing the formula in the area you would like to display the outcome: 

 

 

Error.

User does not have sufficient privileges to access this Content
Learn More