TRIM function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
TRIM
removes excess spaces from a text string.
Syntax:
TRIM(text)
- returns text with any leading or trailing spaces removed, and with any multiple spaces replaced with a single space.
Example:
TRIM(" Good Morning ")
- returns Good Morning.
See Also
