Remove leading and trailing spaces from Excel worksheets

Trim 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.

Trim leading and trailing spaces from Excel cells.

How to remove extra spaces with Trim Spaces for Excel

  1. In your Microsoft Excel worksheet, select the cells, columns or rows from which you want to remove excess spaces.
  2. 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.
  3. 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

 
Contact us