Add an easy way (Ribbon button) to change text casing (UPPER, lower, Sentence, etc.)
Currently Excel is the only Office application that doesn't have the ribbon-button to change selected text to uppercase or lowercase.
The only way to do it is to use the function =UPPER() and then copy/paste the resulted value into the original cell.
It would be good to have a button to change the selected text to uppercase or lowercase.
I would like to see Change Case added to Excel's text formatting options. I need to standardize the appearance of data, highlighting one or more columns and clicking an icon would be so much easier. In my job, I import A LOT of Excel tables into various databases and this would save a significant amount of time. Thank you.
Henry Smith commented
I installed the Add-In for Case Changing and it works well. However, the cell does not maintain any memory. So, if i want values in a cell or a range of cells to always be Upper Case, this Add-In does not work for that scenario. A better option in my opinion would be to have an option for Upper/Lower/Title case in the "Cell Format" area where you can toggle these items on or off and they remain that way in the spreadsheet. By that, I mean that any value that I enter or change in a specific range of cells will always be upper/lower/title case regardless of how i type it in on the keyboard.
It can be done in Publisher, why not Excel?
this would be super helpful...
By adding Word's "Change Case" options to Excel it would improve Excel's editing abilities and increase customer productivity adding value to the Excel product
Allen ... your post is most impressive. I watched your video and it is AMAZING. But it seems "too good to be true." How can I trust that loading this is not a mistake. Normally doing such is not recomended.
Allen Reed commented
Go Here for a FREE "Change Case" ADD IN https://github.aneejian.com/Change-Case-Excel-Add-In/
Built by another Office user/Developer & I have been using this add in for about 1.5 to 2 months and so far no problems with it and works great.
You cannot use it while editing the cell although when done editing select the cell or cells you want to change and then use it. I think it would be impossible to build a "Change Case Option" that would work while you were editing a cell, although I am not really versed as most in development, it just makes sense to me is all but I could be wrong.
As I get time I try and learn as much as I can so when I enquire enough knowledge to built things like this I will also share with everyone for free. If everyone could pitch in like this for each other without having to make money on every little add in they build it only brings everyone closer to working together. Doing just little things like this for each other would only be another step in the right direction of working together towards making a better future for everyone and not just computers. It's always the small things that count, we don't have to give our whole lives. . Use this so they can work on other bigger things for excel making it better.
This thread seems to be the same as: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/18448030-put-change-case-in-excel-please
SERIOUSLY … Word has had Charge Case option for 25 years … how many time have users asked you for this in Excel … probably 100's of 1000's of times thousands of times. I'm gonna download LibreOffice to see if it has the option. Bill Gates better hope it doesn't!
Here is a easy to use add-in.
Kurt Saldutti commented
I guess what we’re saying here is do not ever expect any help with what Microsoft could correct in a heartbeat. They simply could add the change case tool in Excel but refuse to even talk about it. Instead that actually expect us to use that insane clumsy cut and paste add cell insanity. Such a sorry bunch.
Jeff Stubing commented
You can do it pretty easily if you are good with macros: Select the range for which you want to change the case, then run a macro which: Sets the selection to a range variable, inserts a column to the right (or below if desired), inserts an UPPER or LOWER formula for those cells into the new column or row, copies the new range of formulas, pastes values over the originally selected range, and deletes the now unneeded column or row.
Edward Bemis commented
The PROPER function only works by adding a column. If you have 10 columns to change the case on you now need to add 10 additional columns. Moving to Word and returning risks data integrity. Just add the Change Case button please.
Add CHANGE CASE buttons and make it easy for us. Mac does.
Locke Garmin commented
If this suggestion doesn't get implemented you could use a UDF to solve the problem with the VBA code below.
Function TOGGLECASE(Text As String) As String
Dim x As Long
Dim Character As String
Dim NewTextArray As Variant
ReDim NewTextArray(1 To Len(Text))
For x = 1 To Len(Text)
Character = Mid$(Text, x, 1)
Select Case Character
Case "A" To "Z"
NewTextArray(x) = LCase$(Character)
Case "a" To "z"
NewTextArray(x) = UCase$(Character)
NewTextArray(x) = Character
TOGGLECASE = Join(NewTextArray, vbNullString)
Dennis Taylor commented
Yes, like Shift+F3 in Word, which provides one of these two cycles for selected text:
change from all lower to all upper to all title case (like the PROPER function), or
change from all lower to all upper to all sentence case.
Yes, please add "Change Case" to Excel for those of us who process words from our colleagues spreadsheets that we are editing as well as numbers and formulas.
The Excel functions: UPPER, LOWER, and PROPER do not do what "Change Case" does and is needed to do.
Copying and pasting from MS Word to MS Excel just to use the Change Case feature in Word just doesn't cut the mustard.