Title: Remove extra spaces in Excel 2016 - 2007 with Ultimate Suite
Headings: Remove extra spaces in Excel
Remove extra spaces in Excel
Before you start
How to trim spaces in the range

Content: How to trim spaces in the range
To run the needed tool, click the Trim Spaces icon in the Text group on the Ablebits Data tab: Then simply pick the needed options: Select the range where you want to remove extra spaces in your Excel worksheet. If you want to highlight the whole table quickly, click the Expand selection icon. Choose the option or a combination of options that suits you best: If you pick Trim leading/trailing spaces, the spaces before and after cell values will be deleted. By ticking Trim spaces between words to 1, you'll have extra spaces between words within a cell removed. The Trim ' ' option means that non-breaking spaces that look like   in your worksheet will be deleted from the selected range. Tip. You can run any of these options right away by clicking the down arrow below the add-in's icon and picking the necessary option from the drop-down menu: