TRIM

Removes all leading and trailing spaces from a text string and converts multiple spaces inside that text string into single spaces.

Syntax:

TRIM(text)

Example:

TRIM(" sloppy typing ")

would return the text string "sloppy typing".