The TRIM function is to remove the extra spaces except for the single spaces between words.
Formula:
=TRIM(text)
Explanations:
Text is required, the text that you need to remove spaces.
Cautions:
The TRIM function cannot remove the nonbreaking space character , which is commonly used in Web pages.
Example: Remove extra spaces in cell A3.
= TRIM(A3)
The extra spaces in the middle in cell A3 were removed, returning the result "How to Use Trim Function".