How To There are spaces between numbers and characters in excel.
There are unwanted spaces in an excel spreadsheet.
Step 1: To remove all spaces, highlight the range in which you want to do it.
If you want to remove spaces from C2 through C30, highlight those cells.
Step 2: You can click on the menu.
Step 3: Select the one you want.
Step 4: Select to replace.
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 the one you want to replace.
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: Substitute type.
Step 11: The first cell has spaces.
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 www.wikihow.com.
Step 16: The cell has a formula you typed.
The cell needs to be highlighted.
Step 17: The cells you want to fill will be covered by the fill handle.
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.