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:

TRIM Function in Excel 1

In all of the above examples extra spaces are removed and only one space between each word is kept.so the result will be

Result:

TRIM Function in Excel 2

previous-small TRIM Function in Excel                                                                                                                next_small TRIM Function in Excel