Title: 3 ways to remove spaces between words / numbers in Excel cells
Headings: 3 ways to remove spaces between words / numbers in Excel cells
3 ways to remove spaces between words / numbers in Excel cells
Trim blanks between words to 1, remove trailing / leading spaces
Use the Trim formula to remove extra spaces
Using Find & Replace to remove extra spaces between words
3 clicks to neat data with Trim Spaces tool
Remove all spaces between numbers
Using formula to remove all spaces
Video: how to remove spaces in Excel
You may also be interested in

Content: That's it! We deleted all excess blanks with the help of the formula trim (). Unfortunately, it's a bit time-consuming, especially if your spreadsheet is rather big. Note: If after using the formula you still see extra spaces (the last cell on the screenshot), please have a look at If the TRIM Function Doesn't Work
Using Find & Replace to remove extra spaces between words
This option needs fewer steps, but allows only deleting excess spaces between words. Leading and trailing spaces will also be trimmed to 1, but will not be removed. Select one or several columns with the data to delete spaces between words. Press Ctrl + H to get the " Find and Replace " dialog box. Press the Space bar twice in the Find What field and once in Replace With
Click on the " Replace all " button, and then press Ok to close Excel confirmation dialog. Repeat step 4 until you see the message "We couldn't find anything to replace." :)