Remove Spaces Trim formula Excel how to
If you use Excel then you are bound to come across this issue when importing data from another software into Excel. Extra spaces have been added between the start, end or in-between words or a mix of all three. This can be a real pain if you are not aware of the =trim formula.
Just type =trim and click on the affected cell and hit enter
Trim removes the extra spaces between words and also the leading and trailing spaces within seconds
Just drag the formula down and your data has been cleaned