Excel Function: TRIM

The Excel function TRIM allows you to remove unnecessary spaces at the beginning and end of a string as well as excess spaces within the string.



Example of use

The goal here is to remove all unnecessary spaces from the data contained in column A.

To do this, enter into cell B2:

excel function trim

Then drag down:

excel function trim space