Comments on: 4 ways for changing case in Excel

In this article I'd like to tell you about different ways to change Excel uppercase to lowercase or proper case. You'll learn how to perform these tasks with the help of Excel lower/upper functions, VBA macros, Microsoft Word, and an easy-to-use add-in by Ablebits. Continue reading →

Comments page 2. Total comments: 164

  1. Thanks Soo much, extremely helpful

  2. Thanks a lot.. Great tool ..

  3. THANK YOU VERY MUCH! This really saved me a lot of time..

  4. Right.... PROPER function made my day... Saved lot of my time.
    Thanks a lot

  5. This is amazing and very helpful. I wonder too why Excel does not have the functionality MS gave Word. Thanks for saving many of us a time trying to figure things out on our own

  6. Super

  7. Thank you for the infacting knowledge.

  8. Upper case Formula works Perfect.
    Do you have any Formula to add Time with different cells and rows ?

  9. thanks for this please i will like to be more expert in Excel how can i be upgrading myself

  10. THANK U VERY MUCH

  11. Thanks for your post & simple explanations.

  12. Most helpful post...thanks

  13. Thanks a lot for the helpful post!

  14. Your blog is Not useful, its not that much complex, you just need to select a cell and press shift+f3

    1. Ouch she's right, slaughtered you.

    2. Hello!

      The Shift+F3 shortcut changes text case in Word. In Excel, it opens the Insert Function dialog box.

  15. Never knew about the PROPER function .. thanks

  16. Capitalize first letters awesome..........:)

  17. thanks a lot
    Im satisfactory to solve my problem

  18. Thank you!!

  19. Very useful information for changing cases in Excel. Thank you and with best wishes for you.

  20. I will always be grateful for this I have been having a lot of issues when it comes to changing cases in my excel data. thanks

  21. Absolutely very important article. The Ablebit Add in makes it so easy and simple with even more options at your disposal. Thank you very much and God bless you

  22. Thanks

  23. Thank you

  24. Such BS just to get upper case changes made in Excel. Microsoft - you can do better than this. It should be in the list to add to the menu instead of making us create formulas or go to a site to DL an add on. SMH Making it too hard.

  25. A very helpful write up

  26. Thank you so much for this article! The steps were super clear and easy to follow. And you just saved this busy art teacher hours of retyping names!!

  27. NICE EXCELLENT

  28. Very very useful. i am searching since long. Thank you.

  29. This article is a life-changer for me as I just started out in Admin a year ago and am still learning all the computer short-cuts to make work less tedious and repetitive.
    Great job!
    And, Thank you

  30. I have download the addin, but the menu is not there

    1. Hello, Faried,
      I’m very sorry to hear that you’re having difficulties with our product.

      If you have successfully installed our add-in, but don't see Ablebits tabs in your Excel Ribbon, please first make sure that the add-in isn’t disabled:
      1 Go to File -> Options -> Add-ins, open the “Manage” drop-down list at the bottom of the window, select “Disabled Items” and click Go. If you see the Ablebits add-in in the list, select it and click the ‘Enable’ button.

      Then make sure that the add-in loads correctly:
      2 Go to File -> Options -> Add-ins again, select “COM Add-ins” from the “Manage” drop-down list and click Go. Find the Ablebits add-in in the list. If it is unchecked, check it and click OK.

      If these steps don’t work for you, please contact our support service team, support@ablebits.com, for further assistance.

  31. Good Working it is helpful for users .
    Thank you.

  32. Thank you for the add, very useful

  33. Thanks a lot. I had known how to copy to MS Word, change case and return, but doing it on my spreadsheet was just mind blowing. I have learnt something new today, thanks to you.

  34. Could the macros or add-ins be modified to include "smart sentence case," excluding acronyms and abbreviations (capital letters either consecutive or separated by periods) and with the option to add exceptions for company and brand names with stylized capitalization (example: BAMTech)?

  35. Thank you sooooo much for this article!!!!!!!!!!! This truly makes my excel work easy and fast :-) More power to you, dear writer!

  36. Very, very useful piece.
    Thanks a lot!

  37. Thank you soo much for this information

  38. Thanks a lot, My problem Solved

  39. I need to change a pasted string such as 2A3177b0Ce8a to 2A:31:77:B0:CE:8A where the incoming data is text representation of a MAC address and the displayed string is upper case text with colons in it I can paste to a text field that requires the formatting I have shown. Any ideas?

  40. VERY HELP FULL THANKS A LOT

  41. This was so helpful and the detailed step by step - right on! Thank you!

  42. Thanks sooo much to solve my problem to see your article.

  43. thank you. it's help me a lot. again & again thanks

  44. thank you. it's help me a lot

  45. This article saved my day. Thank you

  46. Good, you solved my problems of changing Case

    Thanks

  47. Thanks for this.
    Very helpful.

  48. It is very nice way for changing the method ......

  49. Is there any way for the case to be changed AS YOU WRITE the text? I mean to be changed directly when editing the cell, not afterwards by selecting the cell(s) and applying a formula. Thank you for the answer.

      1. I thought your advise would be more helpful and especially more professional. But in front of this answer I realized I made a mistake addressing my question to this site. Very good, because I intended to buy your product. And now, you just saved me 100 EUR! Your company should thank you for chasing away another client :) Keep up your good work, Natalia!!! For other people who are looking the same thing I did, here is the search string you can use in Google: "vba force proper case" (or "... sentence case", if you need). Proper case (in Excel) = Title Case (in Word). You will find the solution.

        1. Eric,

          I sincerely apologize if you were offended by my reply and if the suggested workaround is not what you were looking for. You see, from the task you described it looked like you needed an instant solution for changing the case when you type. Since there are lots of people who are new to Excel and don't know whether this or that works, this was the first obvious thing to offer.

          Though I think the vba as a solution is a bit more complicated than it has to, I'm glad that you've managed to find it and shared it here in case.

          1. My reply is ONLY for people searching same thing as me. Please DO NOT follow Natalia's opinion ("vba is a bit more complicated"). You don't have to learn VBA to be able to apply a script. You can solve it with a simple copy/paste. And using the search string i gave you, you will find complete instructions where and how to paste it. Good luck :)

  50. Thank you so much for excellent solution.

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