How To Remove Spaces Between Characters and Numbers in Excel

There are spaces in an excel spreadsheet.

Step 1: If you want to remove all spaces, highlight the range.

If you want to remove spaces from C2 through C30, highlight those cells.

Step 2: You can click on the menu to change it.

Step 3: You can find it by selecting Find.

Step 4: Select another option.

There will be a dialog box.

Step 5: Click on the box to find what.

Step 6: The space bar is on the keyboard.

Don’t press it more than once.

Step 7: Click to replace it.

The second button is at the bottom of the window.The selected cells now have spaces removed from them.A pop-up will let you know how many spaces have been removed.

Step 8: Click OK if you don’t want to.

Step 9: The blank column has the top cell in it.

The first line of data in the column must be on the same row as the cell.If you want to remove spaces from column C, you can click the second cell in your blank column.E2, F2, G2, etc.

Step 10: The type is substitute.

Step 11: There are spaces in the first cell.

If you want to remove all of the spaces from the C column, click the first box.There is a column that isn’t the title.The formula should look like this if you clicked cell C2.

Step 12: A comma is used to type.

The cell should look like this.

Step 13: “Type”

The space between the two sets of quotes is important.The formula should now look like this.

Step 14: There is a type that you can type.

There is no space between the quotes.The formula should now look like this.

Step 15: Press Enter or Return.

You can see the contents of the selected cell without spaces in the new column.For example, if C2 said something.Your new cell will say

Step 16: The cell has a formula you typed.

The cell needs to be highlighted.

Step 17: You can drag the fill handle over the cells you want to fill.

The data from each cell will show up in your new column.

Step 18: The data from the new column should be copied to the original column.

The new space-free data is here.