To use this function, choose Calc > Calculator.

Removes all spaces except single spaces between words.

Syntax

TRIM(text)

For text, specify the text or column of text.

Example

To remove the additional spaces, enter the expression TRIM(C1) and store the results in C2.