TRIM_WHITESPACE function

The Klipfolio TRIM_WHITESPACE function returns text without leading and trailing spaces.

Syntax: TRIM_WHITESPACE (text)

Example

In the following example, TRIM_WHITESPACE is used to remove the leading white spaces in column A.

 

A

1     James
2     Tim
3     Vicky
4     Laura
5     Mary

 

TRIM_WHITESPACE (A:A)

Returns:
James
Tim
Vicky
Laura
Mary