Apple numbers User Manual

 Dictionary of Functions

 

The TRIM function removes extra spaces from text. TRIM removes all spaces before the 
first character, all spaces after the last character, and all duplicate spaces between 
characters, leaving only single spaces between words.

TRIM(text)

 text:  The text from which you want to remove extra spaces.

  

The TRUE function returns the Boolean value TRUE. It is included so you can use 
spreadsheets created with some older spreadsheet applications. You can specify a 
Boolean value of TRUE by simply typing “true” (without quotation marks) into a cell or 
function argument.

TRUE()

 No arguments (but you must include the parentheses).

Notes
You can type the word TRUE into a cell or formula instead of using the TRUE() function.
  

The TRUNC function truncates a decimal number to the specified number of digits.

TRUNC(number, [digits])

 number:  A numeric expression indicating the number you want to truncate.
 digits:  Optional; the number of digits of the result relative to the decimal point. A 

positive number represents digits (decimal places) to the right of the decimal point. 
A negative number specifies digits to the left of the decimal point, which are 
replaced with zeros. If omitted, 0 is used.

TRIM("     spaces      spaces     spaces      ") returns "spaces spaces spaces".

TRUE() returns the Boolean value TRUE.

AND(1,TRUE()) returns the Boolean value TRUE.

AND(1,TRUE) behaves exactly like the preceding example.