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 3. Total comments: 164
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
Thanks
Thank you
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.
A very helpful write up
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!!
NICE EXCELLENT
Very very useful. i am searching since long. Thank you.
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
I have download the addin, but the menu is not there
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.
Good Working it is helpful for users .
Thank you.
Thank you for the add, very useful
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.
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)?
Thank you sooooo much for this article!!!!!!!!!!! This truly makes my excel work easy and fast :-) More power to you, dear writer!
Very, very useful piece.
Thanks a lot!
Thank you soo much for this information
Thanks a lot, My problem Solved
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?
VERY HELP FULL THANKS A LOT
This was so helpful and the detailed step by step - right on! Thank you!
Thanks sooo much to solve my problem to see your article.
thank you. it's help me a lot. again & again thanks
thank you. it's help me a lot
This article saved my day. Thank you
Good, you solved my problems of changing Case
Thanks
Thanks for this.
Very helpful.
It is very nice way for changing the method ......
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.
Hello, Eric,
What if you simply press Caps Lock? Helps all the time!
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.
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.
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 :)
Thank you so much for excellent solution.
Thanks your article helped me to avoid retyping the document.
Regards
Thank you so much for this. It is informative, detailed and quite helpful. you saved alot of my time
I am looking to have my WORKSHEET entirely UPPERCASE. Is there a way to do so? I realize that your short cuts all affect one or two cells/rows/columns; I need to do the entire sheet.
Thank you.
how use the shortcut key for 2010 ms office means in words document to apply upper and lower case letter....
Requested Sir/Mam,I found a short key in excel to upper case to lower case and lower case to upper case.Please reply me.
Thanks for much for this article. It was informative, detailed and quite helpful.
what is shortcut key of upper and lower and proper case
very helpful article, thank you so much
this is very helpful, thank you.
Thanks a lot
Thanks a lot, it's indeed helpful
Proper is not working for me.
Thank you very much for helping me and saving my time.
Thanks you saved my lot of times to change in uppercase. I'm working on copy paste work. & your article is good for me thanks again. :)
Hi Sir/Madam
I want to know formula in excel for make short letter from sentence.
Example A1= Roumdul White Rice, the result =RWR
Please help me as soon as possible.
thank
Hi Sam,
the logic for your case is to find all the "spaces" and then convert the next character to uppercase and add them all into one string. There are a couple of challenges with this. First, how many spaces will be there in each of the text? Excel does not have a looping function to keep running for several times. So the number of spaces should be definable. Second, there should not be any cases where you would want a different logic of shortening. For example, if there are two cases where the characters are same RWR, you might want to adjust one of them to differentiate. This would call for AI.
The second issue is hard to crack. But for the first one, we can solve it using the Text to column function to split the text at each space. Based on the number of spaces, your text would be sitting in multiple columns and you can enter the formula in an empty column to add all the first characters of the different columns.
Taking the example you have provided, there would be three columns - A, B, C - where the text would be. Your formula will be in column D as "=upper(left(A1,1))&upper(left(B1,1))&upper(left(C1,1))"
If your text has 4 words (4 spaces), it will be spread in 4 columns (A, B, C, D) and you have to add one more &upper(left(D1,1)) to the formula. The good thing about this formula is that it will work with text that has lesser words as well.
Hope this helps
This is a very quick guide and was very helpful.. the short cut (Shift + F3) didn't work for me.. i use Excel 2010. i had to make use of the formular.
thanks.
Thank you very much! Its save a lot of time for me
wonderful, this methods are simply
extraodinary, it have saved me lots and lots of stress keep it up.
Thank's for given me lot of Excel information.
PETER SMITH = Peter Smith
JOHN MCTEAR = John Mctear
But I need a correction to read
JOHN MCTEAR = John McTear
Excellent article but how would you solve the above.
I don't think there is any way to solve the issue. This is something that needs (extremely basic) AI logic. For example, if "Mc" is the only case where this applies, you can add a formula to catch that. Its complicated, but the logic is - 1. Find the position of the text "Mc" ---- 2. Change to proper case the text until "Mc" ---- 3. Change to proper case the rest of the characters.
In your case, the position of Mc is 7 (step 1). So characters until Mc (7+1) will become John Mc when using proper case (step 2). then the characters after that when changed to proper case will become "Tear" (step 3) - Combine all three, you get John McTear.
See the below formula - the "Find" function returns an error if the text (Mc) is not present. Hence the entire formula is packed inside an iferror function. Obviously, A1 is the cell where the original name is.
=IFERROR(LEFT(PROPER(A1),FIND("MC",UPPER(A1))+1)&PROPER(RIGHT(A1,LEN(A1)-FIND("MC",UPPER(A1))-1)),PROPER(A1))
Hope this helps.