Remove Leading or Trailing Spaces From Excel with Trim Spaces Add-in
ADVERTISEMENTS
Often the data extracted from various sources like database, log files are imported into Office Excel file. It often comes with some extra spaces which is invisible to your eyes, only when you future process this excel sheet it becomes visible.
for e.g while removing duplicates, 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. If there is fewer data then you can manually remove these spaces but if its large excel file then Trim Spaces add-in for Office Excel 2007 is best suited for you.
Trim Spaces Add-in is compatible with Microsoft Office 2007, 2003, 2000 and Office XP Excel 2002.
Trim Spaces Add-in for Office Excel
