Excel’s TRIM function, one of Excel’s text functions, can be used to remove these unwanted spaces.
The syntax for the TRIM function is:
= TRIM (Text)
= TRIM (Cell Number)
TRIM removes extra spaces from the text, so it will leave only single spaces between words and no space characters at the beginning or at the end of the text.
- TRIM is used to cleaning up text that has come from other applications.
- TRIM only removes the ASCII space character (32) from the text.
- The Unicode text often contains a non-breaking space character (160) that appears in web pages as the HTML entity, This will not be removed with TRIM.