Remove Spaces between Characters and Numbers in Excel

3 Parts:

Steps

Video: Remove Spaces between Characters and Numbers in Excel

Comments

You're watching VisiHow. In this video, we're going to show how to delete all of the spaces from a column in Microsoft Excel. In this particular example, we have data obtained from Keyword Planner tool by Google. In each of these keywords, we want to delete all of the spaces to mimic a web site domain.

1. 1
   To delete spaces, select all of the column by clicking the top of it

   .

   Let's click column "B".

   

   Was this step helpful? Yes | No| I need help
2. 2
   Once everything is selected, we can press "Ctrl" + "H"

   .

   

   Was this step helpful? Yes | No| I need help
3. 3
   You can also click "Edit"

   .

   

   Was this step helpful? Yes | No| I need help
4. 4
   Then, move the cursor to "Find"

   .

   

   Was this step helpful? Yes | No| I need help
5. 5
   Then, click "Replace..."

   

   Was this step helpful? Yes | No| I need help
6. 6
   You need to find all the spaces

   .

   To do that, press the space bar in the "Find what:" field.

   

   Was this step helpful? Yes | No| I need help
7. 7
   Then, click the "Replace with:" field

   .

   Make sure it's empty.

   

   Was this step helpful? Yes | No| I need help
8. 8
   Click "Replace All"

   .

   

   Was this step helpful? Yes | No| I need help
9. 9
   Then, click "OK"

   .

   

   Was this step helpful? Yes | No| I need help
10. 10
    Now, close the "Replace" window

    .

    You'll see that Excel has deleted all of the spaces within column "B".

    

    Was this step helpful? Yes | No| I need help

If you have any questions or comments on how to delete all of the spaces in Excel, please leave them in the space below. Thanks for watching VisiHow! Have a great day!

If you have problems with any of the steps in this article, please ask a question for more help, or post in the comments section below.

Comments