T

Formulas / T
Filter text values only.

=T(value)

Examples

=T("NASA")
The T function is a text function that is used to convert any value or text string into a text value. If a value is passed into the T function, it will return the same value in text format. An example is this formula, which will return "NASA".
=T(100)
If a numerical value is passed into the T function, it will return an empty string, such as above, which will return "".

The T function is a useful tool for testing whether a given value is text, as it returns the text referenced by that value.

The T function removes non-text values and numeric values and is provided for compatibility with other spreadsheet programs; Sourcetable automatically converts values when needed.
The T function returns text when given a text value and an empty string ("") for numbers, dates, and the logical values TRUE and FALSE.

What is the T function?

The T function is a function that returns the text referenced by a value. It is often used to test if a value is text or not.

What type of value can the T function return?

The T function can return any type of text, including strings, numbers, and characters.

Can I use the T function to test if a value is not text?

Yes, you can use the T function to test if a value is not text by checking if it returns empty text.

What are some examples of when I might use the T function?