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: All spaces are removed. Using formula to remove all spaces
You may need to delete all blanks, like in a formula chain. To do this, you can create a helper column and enter the formula: =SUBSTITUTE (A1," ","")
Here A1 is the first cell of the column with numbers or words where all spaces must be deleted. Then follow the steps from the part using formula to remove extra spaces between words to 1
Video: how to remove spaces in Excel
You may also be interested in
Excel TRIM function - quick way to remove extra spaces
How to use LEN function in Excel to count characters in a cell
How to remove all blank rows in Excel