Remove leading and trailing spaces from Excel worksheetsTrim Spaces for Microsoft Excel 2010-2000 | |
The Trim Spaces for Excel add-in will help you quickly remove leading and trailing spaces in the selected cells, columns, rows or the entire table. Just select the region that you want to clear up, click the "Run" button of the add-in and no excess spaces are left in your worksheet. |
How to remove extra spaces with Trim Spaces for Excel
- In your Microsoft Excel worksheet, select the cells, columns or rows from which you want to remove excess spaces.
- Start the Trim Spaces by clicking on its icon, or go to Excel Menu Ablebits.com -> Trim Spaces for Excel.
If you have Excel 2007 or 2010, you can find it on the Ablebits.com tab on the Ribbon.
- Click the "Run" button and enjoy the results!
If your cells have more than just leading and trailing spaces
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, this advanced tool can process larger volumes of data as it supports all Excel versions from 2003 to 2013 32 and 64-bit.
Trim Spaces for Microsoft Excel system requirements
Microsoft Excel
- Microsoft Excel 2010 (32bit)
- Microsoft Excel 2007
- Microsoft Excel 2003
Operating System
- Windows 10 (32 and 64-bit)
- Windows 8 (32 and 64-bit)
- Windows 7 (32 and 64-bit)
- Windows Vista (32 and 64-bit)
- Windows XP (32-bit)
- Windows Server 2003, 2008, 2012
Trim Spaces for Microsoft Excel version
Current add-in version: 1.3.7
published on: Jun 20, 2013