TRIMSIDES

Removes leading and trailing spaces from text, leaving all other spaces intact

Usage

TRIMSIDES(text)

Parameters

text

(Required) The text from which to remove leading and trailing spaces

Examples

Example With these variables Result

TRIMSIDES(“ Hello World “)

(None)

“Hello World”

TRIMSIDES(message)

message is " Good Morning Anna "

“Good Morning Anna”

More information

The TRIMSIDES function will not change the value of the variable itself. It will return the text without leading and trailing spaces, but if you use the variable elsewhere, it will still have its original text with leading and trailing spaces.

See also