Formulas and Functions

Chapter 11 Text Functions 323
T
The T function returns the text contained in a cell. This function is included for
compatibility with tables imported from other spreadsheet applications.
T(cell)
 cell: A reference to a single table cell. cell is a reference value to a single cell that
can contain any value, or be empty.
Usage Notes
If the cell doesn’t contain a string, T returns an empty string. Â
Examples
If cell A1 contains “text” and cell B1 is empty:
=T(A1) returns “text”
=T(B1) returns nothing.
Related Topics
For related functions and additional information, see:
“Listing of Text Functions” on page 306
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
TRIM
The TRIM function returns a string based on a given string, after removing extra spaces.
TRIM(source-string)
 source-string: A string. source-string is a string value.
Usage Notes
TRIM removes all spaces before the rst character, all spaces after the last character, Â
and all duplicate spaces between characters, leaving only single spaces between
words.
Example
=TRIM(” spaces spaces spaces “) returns “spaces spaces spaces” (the leading and trailing space were
removed).