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: 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: We always recommend selecting the Back up the worksheet option to keep your original table intact. Click the Trim button to remove all extra spaces in one click. Change Case in Excel
Add Text in Excel
Extract text and numbers
Remove unwanted characters
Convert text
Split text by characters, mask, strings
Split names: first name, middle name, last name, salutation, name suffix