This add-in removes spaces at the beginning and end of individual cells in Excel. If you deal with data that needs to be cleaned up, this add-in will save a lot of time. Only spaces at the beginning and end of cells will be removed. All other characters will remain as will spaces between letters and/or numbers.

Note, if this add-in is used with formulas, the formulas will be replaced by the result (i.e., =2+2 will be replaced with 4).

Remove Trailing and Leading Spaces

System Requirements & Download

Remove Trailing and Leading Spaces Download

Download 13.09 KB 1517 downloads

Before

After

When you click the download button above, choose “Save As” and then select the location to save it. See the links below for more detailed instructions.
    • Clean Data
    • Removes Leading Spaces
    • Removes Trailing Spaces
    • Learn Something New
How to Install an Excel Add-in 2007 and 2010

After you’ve installed an Excel Add-in, you can go here and add the add-in to your quick access toolbar.

On October 24, 2015   /   Downloads, Excel Add-in, How To, Useful Resources