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: how to remove spaces in Excel
Trim blanks between words to 1, remove trailing / leading spaces
For example, you have a table with 2 columns. In the column Name, the first cell contains "John Doe" written correctly without excess spaces. All other cells have extra blanks between the first and the last names. At the same time these cells have irrelevant blanks before and after the full names known as leading and trailing spaces. The second column is called Length and shows the number of symbols in each name: 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.