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 the data further, say in order to remove duplicates. If you try to do this using either the standard Excel function, or our add-in for removing Excel duplicates, no duplicate entries will be found, though you definitely know they do exist in your worksheet. The reason is obvious - excess spaces that you are not even aware of.
The Trim Spaces for Microsoft Excel add-in will quickly remove leading and trailing spaces from your worksheets. Just select the cells, you can select some columns, rows or the entire table, click the "Run" button and no excess spaces are left in your Excel worksheet.
Extra spaces between the words, non-breaking spaces, other formatting issues like numbers stored as text or words written in a wrong case can all hamper your work with data in Excel. In this case your best aid is the Cell Cleaner add-in.
Besides cleaning up cells in your worksheets it can process much larger volumes of data as it supports all Excel versions from 2003 to 2010 32- and 64-bit.
I just wanted to say well done for developing such a fantastic program and you have saved me a huge amount of time. Oh and it worked perfectly :) Many Thanks Matthew.
Free for private and commercial use
The setup.exe and the add-in's DLLs are signed with the VeriSign code signing certificate
Click Like and get 15% discount on all our products right now!
Copyright © 2003 - 2012 Add-in Express Ltd. All rights reserved.
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
