TRIM function is used for the removal of extra space characters. 

When the excess spaces appear between two words, the function keeps only one space character.


Notice the extra spaces removed from the beginning of the cell, as well as the spaces that were removed between “Hello” and World!”, except a single space character that was kept. 



text – We will enter the text from which we would like to remove the redundant spaces. We can also reference a cell. 

Practice TRIM function

So, now it’s time to see how the TRIM function works: