TRIM

Removes extra spaces from text, leaving only single spaces between words and no leading or trailing spaces

Usage

TRIM(text)

Parameters

text	(Required) The text from which to remove extra spaces

Examples

Example	With these variables	Result
TRIM(“ Hello World “)	(None)	“Hello World”
TRIM(greeting)	greeting is " Good Morning Anna "	“Good Morning Anna”

More information

The TRIM function will not change the value of the variable itself. It will return the cleaned text, but if you use the variable elsewhere, it will still have its original text with extra spaces.

TRIM

Usage

Parameters

Examples

More information

See also