Trim Space -- An Add-In for Microsoft Excel
RandallS - Wed, 2009-11-11 16:47
While extra spaces usually aren't a problem when you are entering data by hand in Microsoft Excel, they often worm their way into data that import from other formats. Once in your spreadsheet they can be hard to find and they will often foul up your spreadsheet to the point it doesn't print -- or even work -- correctly. Manually finding these extra spaces at the beginning and/or end of items is a time-consuming and error-prone process.
Fortunately, the free Trim Spaces addin for Microsoft Excel can remove them in three easy steps: select the cells you need checked, use the Excel menu or toolbar to activate the Trim Spaces add-in, and press the run button in the Trim Spaces dialog box. Trim Spaces will do its thing in a flash, removing all leading and trailing spaces from the selected cells in your spreadsheet. If you work with Execl and imported data a lot, this little add-in can save you a long of hair-pulling.
Operating System: Windows with Microsoft Excel 2007, 2003, 2002 (XP) or 2000
Web Site: http://www.ablebits.com/excel-trim-spaces/index.php