How to Change the Case in an Excel Spreadsheet

Microsoft Excel has several options for entering text into cells. You can capitalize in the same way that you would in a word processor (by using the "Shift" key). However, if you want to change the case of a word, Excel has several functions that can change the case of text in a file. The "LOWER" function converts uppercase to lowercase, the "UPPER" function converts lowercase to uppercase, and the "PROPER" function capitalizes the first letter of each word.

...
Change the case of text with a function.

Step

Type the following formula into the cell directly to the right of the cell you want to change the case in:

Step

\=LOWER(A1)

Step

Change "A1" to the cell number you want to change. For example, if your text is in cell B3, then change "A1" to "B3" so that the formula reads:

Step

\=LOWER(B3).

Step

Change "LOWER" to "UPPER" or "PROPER," if desired. (Leave the function intact if you want to change to lowercase).

Step

Press "Enter." Excel converts the text to the new case.

Step

Copy the new data and paste it over the original cell to replace it.

Step

Delete the cell with the function in it.