T
Formulas / TFilter text values only.
T(value)
- value - the value to test
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 "".
Summary
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.
Frequently Asked Questions
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?
- To test if a value is text or not
- To find the text referenced by a value
- To check if a value is empty
