Documentation/How Tos/Calc: TRIM function
From Apache OpenOffice Wiki
< Documentation | How Tos
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:
CLEAN, FIND, PROPER, REPLACE, SEARCH, SUBSTITUTE
Functions listed alphabetically, Functions listed by category