Removing excess leading and trailing spaces from Microsoft Excel

Trimming leading and trailing spaces in Microsoft® Excel® sheets

Trim Spaces for Microsoft® Excel®

For Microsoft Excel 2007, Excel 2003, Excel 2002, Excel 2000.

When you import data in Microsoft Excel from an external data source, it often comes with some extra spaces. These spaces are invisible and, in fact, present no problem unless you have to process data further, say, to remove duplicates. If you try to do this, say, using the standard Excel function, or a third party add-in for removing duplicates, no duplicate entries will be found, though you definitely know they do exist in your worksheet. The reason is obvious - excess leading or trailing spaces that you are not even aware of. The Trim Spaces for Microsoft Excel add-in works in Microsoft Excel 2007, 2003, 2002 (XP) and 2000.

The Trim Spaces for Microsoft Excel add-in helps you remove leading and trailing spaces in selected cells. Just select a cells, click the "Run" button of the add-in and no excess spaces are left in your Microsoft Excel worksheet.

How to delete excess spaces with Trim Spaces for Excel: 3 easy steps

1. In your Microsoft Excel worksheet, select the cell(s) from which you want to remove excess spaces.
2. Start the Trim Spaces by clicking on its icon , or go to Excel Menu Ablebits.com -> Trim Spaces for Excel.
   
3. Click the "Run" button and enjoy the results!

Now, there are no more extra spaces in your Microsoft Excel sheets, you can use our Duplicated Remover and enjoy the results!