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".