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: Use the Trim formula to remove extra spaces
Excel has the Trim formula to use for deleting extra spaces from text. Below you can find the steps showing how to use this option: Add the helper column to the end of your data. You can name it "Trim". In the first cell of the helper column ( C2 ), enter the formula to trim excess spaces =TRIM (A2)
Copy the formula across the other cells in the column. 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.