Comments on: 3 ways to remove spaces between words / numbers in Excel cells

3 quick ways to remove extra spaces between words to 1 or to delete all spaces from Excel cells. Using trim formula, using Excel Find & Replace, using special Excel add-in to clean up cells' content. Continue reading →

Comments page 8. Total comments: 265

  1. How i can remove 12333 back spaces from my data. please answer ASAP thanks

  2. I cannot get this to work if the number starts with a 0, like many UPC codes. It removes the 0 as well. Any suggestions?

  3. not working!

  4. how to remove spaces before date.

  5. i am copy some data in same sheet and paste in same but same space is coming how to remove i used trim option also but starting some space coming after that word starting. so what to do
    like-
    _________ABCD

  6. I found this tip helpful:

    With your data selected, press Ctrl+H, click in the Find box, hold Alt key and type 0160 on the number keypad. Leave the Replace box blank and press Replace All

    1. Best Solution. Thanks

    2. Thanks for sharing. Finest and easiest solution of all.

    3. THANKS FOR THE SOLUTION

    4. Nice one. Just putting a space throws an error, but this works great and is much easier than any of these other suggestions. Thanks mate.

    5. This is the best solution! Thanks for sharing

  7. Well, just to let you know this does not work. Spaces are still there!!!

    1. Dear it work same like function of =substitute(Cell Ref No.," ","")

      Thanks

  8. How to remove the space in a column having numbers ending with single space.
    Amount
    65375
    45575
    18088
    54147

  9. Thank you sir

  10. Thanks a lot bro.. it was helpful..

  11. it was nice learning new tips but help on how to delect the first six alphabet fro these GAP GRE YTR 453 VM TO YTR453VM ON A ARRAY OF MULTIPLE DATA

  12. Perfecto

  13. how to remove multiple space before numbers in excel. 100 cells contain different space.

  14. How to remove left space for multiple line in one cell

    ----------
    John Doe
    John Doe
    John Doe
    ----------

  15. Thank you...

  16. Super............

  17. Too good buddy..keep up

  18. Oops!! i was just checking for validation. Anyways good Information in here for trimming!!

  19. thanks it's really nice like magic

  20. I have 12 Mar 2004 but i need 12-Mar-04.

    Please help

    1. Hi,
      1st Replace Space to (-),
      then change the date format.

    2. Change the cell format

  21. please let me know how to make data base on excel?????

  22. Thanks alot ur a life saver

  23. Thanks.
    I have a txt dataset that seems to be seperated with tabs but actually nodes are seperated with space character. I brought it into an excel file and saved it as an csv file then I converted it to an arff file and now I'm openning it in weka but it gives an error to me and say "can not be recognized as an arff file".I don't know what the problem is!

    1. I am not able to determine the cause of the error without seeing your data. If you can send me your file at alex@ablebits.com., I will try to help.

      1. Thanks a lot. It worked out for me.

      2. Didnt work for me too, however found the right way. Select and highlight the space you want to get rid of. Copy this space and select the find and replace. Paste this space in find and replace with nothing. I guess it wasnt a space in the first place. Whatever it was you now find it by copying whatever it was. Hope it works for you.

        1. This worked for me.
          Thanks

        2. Thanks for the solution

        3. Thanks a lot Joel!!!

        4. Yay, great solution!

        5. Thanks that worked for me!

        6. Thanks so much for your help. A simple solution to a very frustrating problem.

        7. worked a treat! thanks

  24. Thank you, useful tips

  25. we can also use text to column function.

    You just insert two or three columns after that data and select the data and go to data (tools)and select text to column delimited and click on space option and other character if available in that data and after that click next button and now you will be able to remove extra spaces in that data.

    Thanks
    Pankaj Parti (india)

    1. Thank you for your comment! Your solution works fine, though it may take just a little bit more time.

      1. how to remove spaces after cheque No.

  26. Very helpful. Many thanks

  27. Thanks! a lot remind me

  28. thanks loads!!

  29. Perfect its wonderful

    1. If you copy numbers from a web page, or Microsoft Outlook, you get leading Blank Spaces and then your numbers will Not sum. You have to remove the leading blank spaces for the numbers to sum as numbers should. Go to Data-> Text to Column->Fixed Width and verify that a line appears PRIOR to the copied number data. Then go to "NEXT" and make sure the tab that says, "General", is selected Then Click "FINISH", and all your Non-summing numbers will now sum properly.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)