Check Sheet Logo
Check Sheet

T

The T function in Google Sheets returns the text representation of a value. If the value is already in text format, it is returned as is. Otherwise, it is converted to text based on the default formatting rules of Google Sheets.

Usage

Use the T formula with the syntax shown below, it has 1 required parameter:

=T(value)
Parameters:
  1. value (required):
    The value to be converted to text format. It can be a number, date, boolean, or any other valid Google Sheets value.

Examples

Here are a few example use cases that explain how to use the T formula in Google Sheets.

Convert numbers to text

The T function can be used to convert numbers to text format, which can be useful when you want to display them as text or concatenate them with other text strings.

Convert dates to text

The T function can be used to convert dates to text format, which can be useful when you want to display them in a different format or concatenate them with other text strings.

Convert boolean values to text

The T function can be used to convert boolean values to text format, which can be useful when you want to display them as text or concatenate them with other text strings.

Common Mistakes

T not working? Here are some common mistakes people make when using the T Google Sheets Formula:

Using T unnecessarily

The T function is only useful when you need to ensure that a value is treated as text. If you are already working with text data, using the T function will not change anything. Make sure you understand the data type you are working with before using the T function.

Forgetting to close parentheses

Like all functions in Google Sheets, the T function requires parentheses to enclose its arguments. Forgetting to close the parentheses will result in a formula parse error.

Related Formulas

The following functions are similar to T or are often used with it in a formula:

  • TEXT

    The TEXT formula is used to format a number into text using a specified format. The format can include special characters such as currency symbols, decimal points, and thousands separators. This formula is useful when you need to display numbers as text in a specific format.

  • VALUE

    The VALUE formula in Google Sheets converts a text representation of a number to an actual number. This formula is most commonly used when you have imported data from another source that is formatted as text, but you need to use it in a numerical calculation.

  • CONCATENATE

    The CONCATENATE function in Google Sheets is used to combine text strings from different cells or inputted directly in the formula. It takes one or more text strings as input and returns a single concatenated string. This function is commonly used to combine first and last names, or to merge data from multiple cells into a single cell.

Learn More

You can learn more about the T Google Sheets function on Google Support.