Documentation/Calc Functions/TRIM

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

TRIM

Category:

Text

Summary:

Removes spaces from a string, leaving only a single space character between words.

Syntax:

TRIM("Text")

Returns:

Arguments:

Text refers to text in which spaces are to be removed.

Additional details:

Examples:

=TRIM(" hello world ") returns hello world without leading and trailing spaces and with single space between words.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: