When you import data in Excel, you also import any blank spaces that come with it, which isn't a problem in day-to-day use. If you try to process the data, though, extra spaces can lead to problems, such as masking duplicate files from tools designed to find and remove them. Trim Spaces for Excel from Add-in Express is a free Excel add-in that can locate and remove leading and trailing spaces in cells in Excel documents.
We installed Trim Spaces in Excel 2010 and opened a spreadsheet. The Trim Spaces Help file opened automatically, while an AbleBits.com tab … Read more