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

  1. good one

    Thank you

  2. I have a problem in my excel

    like 1zw76589246565992 . in right hand side one space is there

    if I try to trim that one it appears trim formula. I don't want it because I want to duplicate the files like 1zw76589246565992 .- 1zw76589246565992

    So please tell me how can I remove the space without appearing formula?...

  3. I have a problem in my excel

    like 1zw76589246565992 . in right hand side one space is there

    if I try to trim that one it appears trim formula. I don't want it because I want to duplicate the files like 1zw76589246565992 .- 1zw76589246565992

    So please tell me how can I remove the space without appearing formula?...

  4. Thanks, I searched a lot for removing space but it worked with call cleaner add-in Finally.

  5. Perfect... its really wonderful

  6. Hi, How am I going to copy paste formula with spaces(filtered) between cells?Thank you!

  7. More then one space in front of numbers , how to remove?

  8. Excellent

  9. 1000
    5000
    2000

    how can i remove the space, plz help

  10. very nice its works........

    but can you tell me now how to copy and paste this corrected excel worksheet data in another sheet. because its not pasted in another sheet.

    and even we delete the previous and unstructured data then automatically corrected data invisible or unstructured in shape of #REF! this.

    so please help me how to use this corrected data or paste this data in another sheet.

    thanks

  11. Reds 19 Joey Votto Red Cool Base Stitched MLB Jersey.Great service of online buy usa soccer sweatshirt,and enjoy
    our cheap nfl authentic jerseys china 79% off.

  12. Its very healpfull

  13. Very helpful. This saved so much time.

  14. Very helpful.
    Thanks a lot

  15. Thanks a lot. Very useful.

  16. VERY HELPFULL

  17. Great job , it really worked for me
    Thanks

  18. dear Sir,

    i would like to remove some extra words from one column,

    how to use trim formula here

  19. How to remove space before and after of /
    Please help on it.

  20. Select the whole column/width Choose find option/Ctrl "S" select space button and replace it .

  21. thanks very much for a good work done

  22. Precisely I got what I want

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

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

    It worked.......

  25. 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."

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

  27. tnx a lot

  28. thanks a lot for your suggestion .

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

  30. Thanks a lot

  31. Thank you mannn...

  32. thank you, very helpful

  33. Thanking you. very useful

  34. plz find ans. this problem

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

  35. Perfect save the day!

  36. Its amazing,,
    Very helpful to everyone

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

  38. 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 )

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

    " 0.29"
    " 1.459"

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

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

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

  43. Thanks you for the guidance

  44. Thanq so much sir

  45. It worked thanks a lot for space

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

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

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

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

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

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

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