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 6. Total comments: 265

  1. thanks very much for a good work done

  2. Precisely I got what I want

  3. can I make my number look like $22 instead of $ 22

    1. Depending on the version of Excel you are running, if you format the cell as currency, it should automatically remove any unnecessary spaces for you.

      I hope this helps

  4. Thank you very much Renat Tlebaldziyeu (Ablebits.com Team)

    It worked.......

  5. 04 100 950105 - this is the original

    04100950105 - i want to make it like this

      1. i hve tried but it is not cming....can u pls guide in formula
        i want to remove space between 04 100 950105 it has to be 04100950105

        1. Try Joel's solution above:
          "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."

  6. Thank you. I just used this to solve a major problem at work now. God bless.

  7. tnx a lot

  8. thanks a lot for your suggestion .

  9. this was wonderful. it saved me hundreds of working minutes

  10. Thanks a lot

  11. Thank you mannn...

  12. thank you, very helpful

  13. Thanking you. very useful

  14. plz find ans. this problem

    you cannot use this command on protected seet to use this command you must first unprotect the seet

  15. Perfect save the day!

  16. Its amazing,,
    Very helpful to everyone

  17. how to remove blank cells from the column in excel sheet.

  18. I try to copy number for web to paste into an excel but i still can't get rid of that space could someone help me please here is the subject.
    (2 917.20 )

  19. Helo,
    Please guide me how to remove space before a Number like below

    " 0.29"
    " 1.459"

  20. Save as Excel 97 - 2003 -workbook (*.xls) format. Now copy the space character from the cell to use in Find and Replace, leave Replace with as blank. Don't know if it matters in which format cells are, only this way worked for me and i have Excel 2016.

  21. hi, I have a column of numbers downloaded from another system, which is in text format, tried all the ways mentioned above but didn't work, could some one please help me out here?

    3 837,87
    1 927,54
    2 208,57
    1 891,05
    1 875,18
    1 880,74
    5 162,41
    66 271,65
    180 815,92
    66 795,78
    200,00
    5 458,81

    thanks,
    Nishanth

  22. WOW its working, thank q very much...

  23. Thanks you for the guidance

  24. Thanq so much sir

  25. It worked thanks a lot for space

    But can we remove the in between empty space in the coloum

  26. Thanks AAAAAAAA LOT... Saves my time and energy.. The Second way...

  27. how to find the spaces between the string.. I don't want to remove those spaces.. but, just want to know is there any spaces in the string or not..

  28. +92 345 5923729
    HOW TO REMOVE SPACE ?
    PLEASE GUIDEME ASAP WHOLE LIST I HAVE

  29. Commission Fees on Order #3047807249291 how to trim characters from figures by using find and replace option if have different numeric figures Commission Fees on Order #3047807249 please share some trick.

  30. T‍YAGI
    How Many Character in Word & Please Describe and Solution..Plz Help Me

  31. 92 300 xxxxxxx
    space not clear please help

  32. Life saver! My co-worker and I spent the longest time trying to figure out how to get of the spaces between our phone number data! I read your tip and voila- it took me 5 seconds:)

    Thank you!!

  33. thanks dude....It will help me a lot

  34. Great post. Thanks!

  35. Thank you so much! Extremely helpful.

  36. thank you so much for this post, it helps me a lot!

  37. thanks a lot, this rescued my report.

  38. great!!!!

  39. THANKX VERY MUCH FOR THE HELP.

  40. its not working for leading spaces

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

  42. 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?

  43. not working!

  44. how to remove spaces before date.

  45. 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

  46. 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

  47. 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

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

  49. Thank you sir

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

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 :)