Remove Trailing and Leading Spaces

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

13.09 KB 138 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.

Disclaimer

The Software Product and any related documentation are provided "As Is." SpreadsheetShoppe makes no warranties, express or implied, and expressly disclaims all representations.
Read the complete End User License Agreement here