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: Feel free to use some tips from Enter the same formula into all selected cells at a time. Replace the original column with the one that has the cleaned data. Select all cells in the helper column and press Ctrl + C to copy data to clipboard. Now pick the first cell in the original column and press Shift + F10 or the menu button . Then just press V.
Remove the helper column. 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.