TRIMLEFT

Removes leading spaces from text, leaving all other spaces intact

Usage

TRIMLEFT(text)

Parameters

text

(Required) The text from which to remove leading spaces

Examples

Example With these variables Result

TRIMLEFT(“ Hello World “)

(None)

“Hello World “

TRIMLEFT(message)

message is " Good Morning Anna "

“Good Morning Anna “

More information

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

See also