Editor: 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.