Change the Case of Text in Cells in Microsoft Excel


There are several methods for doing this; we'll provide them all.

Using Formulas

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.

Using VBA

The following are links to the VBA Express Knowledgebase.

  • For code to change the case of selected cells to upper or lower case, click here.

  • For code to change the case of data when entered to upper or lower case, click here.