The TRIM function removes spaces from text, except single spaces between words.
For example
TRIM("Dear Mr Clinton")
returns "Dear Mr Clinton".
See also:
Other text functions