How to Trim Spaces in Excel

With Text Toolkit for Microsoft Excel

With the Text Toolkit for Excel, you can easily trim excess spaces and leading zeros in the selected cells. In this manual, find out how to use the Trim Spaces utility.

  1. To run the tool in Excel, go to the Home tab and click the Text Toolkit icon:
    Click Text Toolkit.
  2. Select Trim Spaces:
    Select Trim Spaces.
  3. You will see the Trim Spaces pane. Select your options and click the Trim button:

    The Change Case pane.

  1. Select the range of cells where you want to trim unwanted spaces or zeros.
  2. Tick this box to get rid of all zeros before cell values in the selected range.
  3. Pick Trim leading/trailing spaces to remove excess spaces before or after cell values.
  4. Select Trim spaces between words to 1 in case your text cells may have extra spaces between words and you want to delete these spaces.
  5. Choose this option to remove non-breaking spaces.
  6. If you tick the Enable Undo box, the Undo button will appear:
    Tick Enable Undo to be able to Undo.
    As soon as you hit Trim, the Undo button will become clickable and you'll be able to undo the changes made by the add-in:
    Undo the changes.