Remove Spaces between Characters and Numbers in Excel

Edited by Djinu, VisiHow, Eng

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.

Was this helpful? Yes | No
Delete Spaces In Excel.mp4-canvas43 443498.jpg

Ad

Steps

  1. 1
    To delete spaces, select all of the column by clicking the top of it
    .
    Let's click column "B".
    Delete Spaces In Excel.mp4-canvas25 377993.jpg
    Advertisement
    Was this step helpful? Yes | No
  2. 2
    Once everything is selected, we can press "Ctrl" + "H"
    .
    Delete Spaces In Excel.mp4-canvas31 615993.jpg
    Advertisement
    Was this step helpful? Yes | No
  3. 3
    You can also click "Edit"
    .
    Delete Spaces In Excel.mp4-canvas33 427678.jpg
    Was this step helpful? Yes | No
  4. 4
    Then, move the cursor to "Find"
    .
    Delete Spaces In Excel.mp4-canvas34 735988.jpg
    Was this step helpful? Yes | No
  5. 5
    Then, click "Replace..."
    Delete Spaces In Excel.mp4-canvas37 253988.jpg
    Was this step helpful? Yes | No
  6. 6
    You need to find all the spaces
    .
    To do that, press the space bar in the "Find what:" field.
    Delete Spaces In Excel.mp4-canvas43 443498.jpg
    Was this step helpful? Yes | No
  7. 7
    Then, click the "Replace with:" field
    .
    Make sure it's empty.
    Delete Spaces In Excel.mp4-canvas48 379645.jpg
    Was this step helpful? Yes | No
  8. 8
    Click "Replace All"
    .
    Delete Spaces In Excel.mp4-canvas53 693987.jpg
    Was this step helpful? Yes | No
  9. 9
    Then, click "OK"
    .
    Delete Spaces In Excel.mp4-canvas55 991987.jpg
    Was this step helpful? Yes | No
  10. 10
    Now, close the "Replace" window
    .
    You'll see that Excel has deleted all of the spaces within column "B".
    Delete Spaces In Excel.mp4-canvas59 270987.jpg
    Was this step helpful? Yes | No
    Advertisement

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!

Video: Remove Spaces between Characters and Numbers in Excel

If you have problems with any of the steps in this article, please post in the comments section below.

Comments

VisiHow welcomes all comments. If you do not want to be anonymous, register or log in. It is free.

Article Info

Categories : Microsoft Suites

Recent edits by: VisiHow, Djinu

Share this Article:

Thanks to all authors for creating a page that has been read 1,352 times.