TRIM function

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

Syntax

TRIM (text)

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

Example

TRIM(" hello") returns "hello".




Trademarks | IBM Connections wiki