Excel: Trim Function – Getting rid of the extra spaces
Excel: Trim Function – Need to get rid of the extra spaces before or after the text in a cell? In another row or cell, type in the following code, replacing the cell A2 with the actual cell number that you need:
So this: ” This text has leading spaces. ”
Becomes this: “This text has leading spaces.”
(The quotes are just to show the spaces before and after the text)
Now you can copy the value of the new cell over the old value and there you have it!