T

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 Google Sheets 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.

Examples