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: Remove extra spaces in Excel 2016 - 2007 with Ultimate Suite
Remove extra spaces in Excel
If extra spaces in your Excel worksheet don't let process your data correctly, use text tools from Ultimate Suite for Excel. It will help you remove leading and trailing spaces or get rid of excess blanks between words. Here you will learn how to remove spaces in Excel 2016 - 2007. Before you start
How to trim spaces in the range
Related links
Before you start
We care about your data. The add-in will back up your file if you select the corresponding option. 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: