TRIM function

TRIM removes spaces that are in front of a string, or aligns cell contents to the left.


TRIM (text)

text refers to text in which leading spaces are removed, or to the cell in which the contents will be left-aligned.


TRIM(" hello") returns "hello".

Trademarks | IBM Connections wiki