Documentation/How Tos/Calc: TRIM function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 11:30, 29 January 2024 by DiGro (talk | contribs)
Jump to: navigation, search
CALC FUNCTIONS
< {{#switch:Previous Section Previous Section = Previous Section Next Section = Next Section Previous Page = Previous Page Next Page = Next Page }} {{#switch:Next Section Previous Section = Previous Section Next Section = Next Section Previous Page = Previous Page Next Page = Next Page }} >
< {{#switch:Previous Page Previous Section = Previous Section Next Section = Next Section Previous Page = Previous Page Next Page = Next Page }} {{#switch:Next Page Previous Section = Previous Section Next Section = Next Section Previous Page = Previous Page Next Page = Next Page }} >


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.



{{#switch:EN

| RU = Смотрите также: | UA = Дивіться також: | EN = See Also | PT = Ver também | #default = See Also }}

Personal tools