To use this function, choose Calc > Calculator.

Removes all spaces except single spaces between words.



For text, specify the text or column of text.


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

By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy