Home
Wifi Tips
Fix Computer
Windows 10
Windows 11
Artificial Intelligence
Space Science
Strange story
Table of Contents
Using Find and Replace
-
Images 1 of How to Remove Spaces Between Characters and Numbers in Excel Highlight the range in which you want to remove all spaces. For example, if you want to remove spaces from C2 through C30, highlight those cells. -
Images 2 of How to Remove Spaces Between Characters and Numbers in Excel Click the Edit menu. -
Images 3 of How to Remove Spaces Between Characters and Numbers in Excel Select Find. -
Images 4 of How to Remove Spaces Between Characters and Numbers in Excel Select Replace…. A dialog box will appear. -
Images 5 of How to Remove Spaces Between Characters and Numbers in Excel Click the box beneath 'Find What.' -
Images 6 of How to Remove Spaces Between Characters and Numbers in Excel Press the space bar on the keyboard. Make sure to press it only once. -
Images 7 of How to Remove Spaces Between Characters and Numbers in Excel Click Replace All. It's the second button at the bottom of the window. The spaces are now removed from the selected cells. A pop-up will appear, letting you know how many spaces were removed. -
Images 8 of How to Remove Spaces Between Characters and Numbers in Excel Click Click OK.
Using the Substitute Function
-
Images 9 of How to Remove Spaces Between Characters and Numbers in Excel Click the top cell in a blank column. The cell must be on the same row as the first line of data in the column with the spaces.- For example, if you want to remove spaces from column C, and C's first row of data is in row 2 (C2), click the second cell in your blank column (e.g. E2, F2, G2, etc).
-
Images 10 of How to Remove Spaces Between Characters and Numbers in Excel Type =Substitute.[1] -
Images 11 of How to Remove Spaces Between Characters and Numbers in Excel Click the first cell in the column with spaces. For example, if you want to remove all of the spaces from the C column, click the first box (e.g. C2) in the column that isn't the title.- If you clicked cell C2, the formula should now look like this: =Substitute(C2 .
-
Images 12 of How to Remove Spaces Between Characters and Numbers in Excel Type , (a comma). The cell should now look like this: =Substitute(C2,. -
Images 13 of How to Remove Spaces Between Characters and Numbers in Excel Type " ",. There's a space between the two sets of quotes—this is important.- The formula should now look like this: =Substitute(C2," ",.
-
Images 14 of How to Remove Spaces Between Characters and Numbers in Excel Type ''). This time, there's NO space between the sets of quotes.- The formula should now look like this: =Substitute(C2,' ','').
-
Images 15 of How to Remove Spaces Between Characters and Numbers in Excel Press ↵ Enter or ⏎ Return. You will now see the contents of the selected cell (C2, in this example) without spaces in the new column.- For example, if C2 said w ww . wikih ow .com, your new cell will say www.wikihow.com.
-
Images 16 of How to Remove Spaces Between Characters and Numbers in Excel Click the cell with the formula you typed. The cell should now be highlighted. -
Images 17 of How to Remove Spaces Between Characters and Numbers in Excel Drag the fill handle down over the cells you want to fill. The data from each corresponding cell will now appear in your new column without spaces. -
Images 18 of How to Remove Spaces Between Characters and Numbers in Excel Copy the data from the new column to the original column. Your new space-free data is now in place.
4.3 ★ | 8 Vote
