Change the Case of Text in Cells in Microsoft Excel
There are several methods for doing this; we'll provide them all.
Our formulas assume you have your data beginning in Cell A1 and you'll copy down. This is the easiest way for people who need to do it quickly and seldom.
The following are links to the VBA Express Knowledgebase.