Trim Function in Excel

Trim is a very useful Build-in function in excel. The trim function removes all spaces from a text string except for a single space between two words. The trim function removes all the extra spaces from the text string.

Syntax of the Trim Function is

TRIM(text)

In the above example, I have entered 4 types of data.

1 Space Place at the starting of the string.
2  Two spaces between the words.
3 Space place at the end of the string.
4 Many spaces between two words.

I used the =TRIM(A1) function in Column B and you can see that the result of all the four cells is the same.
The Trim function removes all extra space from anywhere of the string.