Cell Cleaner for Microsoft Excel

How to delete leading/trailing spaces and trim blanks between words to one

1. Click on the arrows of the Trim spaces section to open it in the Cell Cleaner pane.
2. In your Microsoft Excel worksheet, select the range where you want to remove excess spaces.
3. Select the option or a combination of options that suits you best:
   • If you choose the Trim leading/trailing spaces option, then the spaces before and after cell values will be deleted.
   • By ticking Trim spaces between words to1, you remove excess spaces between words within a cell.
   • The Trim " " option means that non-breaking spaces that look like   in your worksheet will be deleted from the selected range.
4. Click the Run button to see the results.