All CAPS to lowercase in Excel or Word
All CAPS to lowercase in Excel or Word
(OP)
How can I change Excel files that are all CAPITAL letter to all lowercase letters. Most of these are then put into tables in MS-Word. Word has the option of changing everything to upper case, but not the other way.





RE: All CAPS to lowercase in Excel or Word
It can be done with VBA.
RE: All CAPS to lowercase in Excel or Word
Go to the INSERT/FUNCTION menu and in the popup window scroll down to the "LOWER" choice. Then select the cell you want to convert. If you have consecutive cells to convert just do some dragging or copying.
RE: All CAPS to lowercase in Excel or Word
I didn’t realize there was such a thing as insert/function. That looks like a very handy way to find the function you want and get prompted for the arguments along with some help. Especially for complex functions with lots of arguments that are difficult to remember.
Star for you dogleg
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: All CAPS to lowercase in Excel or Word
Format|Change Case
You can also customize your toolbars to include this functionality as button and it will cycle through the choices that the menu command has, although, lower case is the first choice that pops up with all caps.
TTFN
RE: All CAPS to lowercase in Excel or Word
RE: All CAPS to lowercase in Excel or Word
Once you have tried it, you will never look back!
RE: All CAPS to lowercase in Excel or Word
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: All CAPS to lowercase in Excel or Word
True enough, you don't NEED an add-in - but ask yourself, which is REALLY easier and more efficient:
a) Write a VBA macro.
b) Go to a suitable blank cell; select "Insert | Function | Text | Lower", point to the first cell to be converted and click "OK". (Alternatively, just type in "=LOWER(CellReference)".) Now drag to create a full array of the data which is to be converted to lower case. This creates a copy of the whole range of data at a new location, concerted to lower case.
c) Download ASAP Utilities. Select a range of cells, select "ASAP Utilities | Text | Convert lowercase" and click "OK" - this converts the selected range in-situ - no duplication.
Just my $0.02 worth. Given that it's free, and gives you some 300 useful functions, why not try it?
(And no, in case you are wondering - I am not on commission - just a convert to a great free utility!)
RE: All CAPS to lowercase in Excel or Word
http://www.cpearson.com/excel/case.htm
You can enter these into your personal.xls and then assign them to a button or menu item.
So why do this when there is ASAP? It is true ASAP will provide these functions. But my experience with ASAP was that it had many functions I would never use, and some of its "hot-key" assignments conflicted with my own macros. If you have the expertise, or are willing to invest a couple of hours into learning how, build your own ASAP-like menu using macros defined in PERSONAL.XLS and Excel's built-in ability to customize toolbars, which allows a new drop down menu - ie "My Menu" - to be added. This way you can do more than ASAP utilities, such as formatting page setup with your firms' info in the header/footer, printing your timesheet, or whatever it is you do in Excel. You can still load up ASAP as an add-in for the specialized functions it does so well (I like the table of contents creator), then unload it if necessary.
RE: All CAPS to lowercase in Excel or Word
CODE
Range("F3") = ""
Set mydata = New DataObject
mydata.GetFromClipboard
Range("F3") = mydata.GetText(1)
Range("F3").Value = LCase(Range("F3"))
Range("F3").Cut
End Sub
After the code is done I switch back to the other program and paste the converted text.
This code is a modification of the code at:
http://www.cpearson.com/excel/case.htm
RE: All CAPS to lowercase in Excel or Word
Alt [OEU] ENTER FOR UPPER CASE
Alt [OEL] ENTER for lower case
Alt [OET] ENTER For Title Case
Alt [OES] ENTER For sentence case
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
Steam Engine enthusiasts: www.essexsteam.co.uk
RE: All CAPS to lowercase in Excel or Word
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: All CAPS to lowercase in Excel or Word
Have you ever tried Shift-F3 in Word?
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: All CAPS to lowercase in Excel or Word
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
Steam Engine enthusiasts: www.essexsteam.co.uk
RE: All CAPS to lowercase in Excel or Word
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.