=TRIM
The =TRIM function removes leading spaces, trailing spaces and all double spaces from the text provided and returns the new value.
Syntax
Section titled “Syntax”=TRIM(TextToTrim)Example
Section titled “Example”=TRIM( 123 Sample Street )Returns: 123 Sample Street
Note: Formula functions are case sensitive and must be in all caps.