How to remove extra spaces in Excel – leading, trailing, between words?
If your data set contains unnecessary spaces, the Excel TRIM function can help you delete them all in one go – leading, trailing and multiple in-between spaces, except for a single space character between words.
A regular TRIM formula is as simple as this:
Where A2 is the cell you want to delete spaces from.
As shown in the following screenshot, the Excel TRIM formula successfully eliminated all spaces before and after the text as well as consecutive spaces in the middle of a string.
And now, you only need to replace values in the original column with trimmed values. The easiest way to do this is using Paste Special > Values.