Removing excess leading and trailing spaces from Microsoft Excel

Trimming leading and trailing spaces in Microsoft® Excel® sheets

Trim Spacesfor Microsoft® Excel®

For Microsoft Excel 2010 32-bit, Excel 2007, Excel 2003, Excel XP (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 using the standard Excel function, or our 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 add-in for Excel works in Microsoft Excel 2007, 2003, 2002 (XP) and 2000.

The Trim Spaces add-in can help you remove leading and trailing spaces in the selected cells. Just select the cells, click the "Run" button of the add-in and no excess spaces are left in your 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 Excel sheets, you can use our Duplicate Remover to dedupe Excel lists and enjoy the results!

Trim Spaces for Excel is compatible with

• Operating System: Microsoft Windows 7 (x86, x64), Windows Vista (x86, x64), Windows 2003, Windows XP.
• Microsoft Office Excel 2010 32-bit, Excel 2007, Excel 2003, Excel XP (2002), Excel 2000.

Download Trim Spaces for Excel

The add-in is free for private and commercial use.
Click here to download Trim Spaces for Excel setup file.