Trimming leading and trailing spaces in Microsoft® Excel® sheets



Trim Spaces for Microsoft® Excel®

Microsoft Office Marketplace logo

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.

Trim Spaces for Microsoft Excel

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 ico, or go to Excel Menu Ablebits.com -> Trim Spaces for Excel. Trim Spaces dialog
  3. Click the "Run" button and enjoy the results! Trim Spaces for Excel - result

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


 

Product information

 
Trim spaces for Excel box
Trim Spaces
for Microsoft Excel

version: 1.1



Supports

Excel 2007
Excel 2003
Excel 2002
Excel 2000

Freeware add-in



 

Product list