Trim Spaces for Microsoft Excel

Trimming leading and trailing spaces in Excel worksheets

The Trim Spaces for Microsoft Excel add-in will quickly remove leading and trailing spaces from your worksheets. Follow three simple steps to have your Excel table ready for further work.

  • Select any cell in your table with extra spaces
  • Start the add-in and click the "Run" button
  • All excess spaces are trimmmed in seconds :)

Free download for:

Trim Spaces for Excel - remove leading and trailing excess spaces from Excel worksheets

Free tool that removes extra spaces in your worksheet

When you import data in Microsoft Excel from an external data source, it often comes with some extra spaces. These spaces are invisible and, in fact, present no problem unless you have to process the data further, say in order to remove duplicates. If you try to do this using either the standard Excel function, no duplicate entries will be found, though you definitely know they do exist in your worksheet. The reason is obvious - excess spaces that you are not even aware of. This is when the Trim Spaces add-in comes in handy. Simply install this free tool and run it whenever you come across the issue.

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 2010 32- and 64-bit.

How to delete excess spaces in Excel: 3 easy steps

    Excess spaces are trimmed from the Excel cells
  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 the Excel Ribbon -> Trim Spaces for Excel.
  3. Click the "Run" button and enjoy the results!

See also the most popular add-ins for Excel

Works exceptionally well.

Allows more precise string extraction when mining sentences and parts of words using Excel functions and database commands. ghenley

Simple, fast, amazingly useful for auto-formatting data.

It's available when I need it as a main menu item ( in Excel, works simply, quickly on multiple columns to eliminate extraneous spaces from spreadsheet cells. It's all good. Oh yeah, and it's free! Greg Hatt

I absolutely LOVE your program.

I absolutely LOVE your program. I use Duplicate Remover and Trim Spaces on an hourly basis. I export reports from a software program we use and AbleBits has taken the frustration out of cleaning up the mess that they give me. I recommended you to our IT Company to let their clients know about it and if I find out someone uses Excel I tell them that your program is a definite "must have". Thank you so much, you have shaved countless hours off of my workload. Jeannie C.

You have saved me a huge amount of time

I just wanted to say well done for developing such a fantastic program and you have saved me a huge amount of time. Oh and it worked perfectly :) Many Thanks Matthew.

Free Download
Freeware, 1.7 MB

Trim Spaces for Excel system requirements:

Microsoft Excel

  • Microsoft Excel 2010 32-bit
  • Microsoft Excel 2007
  • Microsoft Excel 2003
  • Microsoft Excel XP (2002)
  • Microsoft Excel 2000

Operating System

  • Windows 10 (32- and 64-bit)
  • Windows 8 (32- and 64-bit)
  • Windows 7 (32- and 64-bit)
  • Windows Server 2008, 2012, 2016

Trim Spaces version

Current add-in version: 1.3.7
published on: 20-Jun-13

End-User License Agreement (EULA).

Featured customers featured customers
Contact us
  Publish your message on our support forum

Our working hours: 0am to 10am PST; 3am to 1pm EST; 8am to 6pm CET.

Ultimate Suite for Excel Professionals
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Sheila Blanchard
Excel add-ins and Outlook tools -