Remove Spaces between Characters and Numbers in Excel

Edited by Djinu, VisiHow, Eng, Anonymous

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 | I need help

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 | I need help

  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 | I need help

  3. 3
    You can also click "Edit".
    Delete Spaces In Excel.mp4-canvas33 427678.jpg
    Was this step helpful? Yes | No | I need help

  4. 4
    Then, move the cursor to "Find".
    Delete Spaces In Excel.mp4-canvas34 735988.jpg
    Was this step helpful? Yes | No | I need help

  5. 5
    Then, click "Replace..."
    Delete Spaces In Excel.mp4-canvas37 253988.jpg
    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.
    Delete Spaces In Excel.mp4-canvas43 443498.jpg
    Was this step helpful? Yes | No | I need help

  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 | I need help

  8. 8
    Click "Replace All".
    Delete Spaces In Excel.mp4-canvas53 693987.jpg
    Was this step helpful? Yes | No | I need help

  9. 9
    Then, click "OK".
    Delete Spaces In Excel.mp4-canvas55 991987.jpg
    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".
    Delete Spaces In Excel.mp4-canvas59 270987.jpg
    Was this step helpful? Yes | No | I need help

    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

Comments

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




Djinu
Featured Author
365 Articles Started
403 Article Edits
21,200 Points
Djinu is a featured author with VisiHow. Djinu has achieved the level of "Lieutenant" with 21,200 points. Djinu has started 365 articles (including this one) and has also made 403 article edits. 97,100 people have read Djinu's article contributions.
Djinu's Message Board
Djinu: Hi, my name is Djinu.
Djinu: Can I help you with your problem about "Remove Spaces between Characters and Numbers in Excel"?
 

Article Info

Categories : Microsoft Suites

Recent edits by: Eng, VisiHow, Djinu

Share this Article:

Thanks to all authors for creating a page that has been read 551 times.

Do you have a question not answered in this article?
Click here to ask one of the writers of this article
x

Thank Our Volunteer Authors.

Would you like to give back to the community by fixing a spelling mistake? Yes | No