Version: 2.2.1 +
The formula 'TrimLeft' removes all spaces from the start of a text string. The spaces between words will not be removed.
Text: this is the text from which you want the spaces removed.
In the following example you can see how the formula 'TrimLeft' works.
Text: " Dear Mr. "
TrimRight: The formula 'TrimRight' removes all spaces from the end of a text string.
Trim: The formula 'Trim' removes all spaces from a text string except for single spaces between words.
If you have any questions about this subject or if you want to provide us feedback please send us an e-mail.