TRIM Function in Excel – Remove Extra Space in Excel
TRIM Function in Excel removes all Extra space from a supplied text string. TRIM function keeps only one space between the words and removes all the extra spaces.
Syntax of TRIM Function in Excel:
TRIM(text)
Where text argument is the text that you want to remove the extra spaces from.
Example of TRIM Function in Excel:
Formula:
In all of the above examples extra spaces are removed and only one space between each word is kept.so the result will be
