How to Remove Spaces Between Characters and Numbers in Excel
Highlight the range in which you want to remove all spaces.,Click the Edit menu.,Select Find., Select Replace…., Click the box beneath “Find What.”, Press the space bar on the keyboard., Click Replace All.,Click Click OK.
Step-by-Step Guide
-
Step 1: 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. ,,, A dialog box will appear.,, Make sure to press it only once., 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., -
Step 2: Click the Edit menu.
-
Step 3: Select Find.
-
Step 4: Select Replace….
-
Step 5: Click the box beneath “Find What.”
-
Step 6: Press the space bar on the keyboard.
-
Step 7: Click Replace All.
-
Step 8: Click Click OK.
Detailed Guide
For example, if you want to remove spaces from C2 through C30, highlight those cells. ,,, A dialog box will appear.,, Make sure to press it only once., 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.,
About the Author
Sophia Cox
A passionate writer with expertise in home improvement topics. Loves sharing practical knowledge.
Rate This Guide
How helpful was this guide? Click to rate: