How to Change the Case in an Excel Spreadsheet

1. Type the following formula into the cell directly to the right of the cell you want to change the case in:=LOWER(A1)
2. 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:=LOWER(B3).
3. Change 'LOWER' to 'UPPER' or 'PROPER,' if desired. (Leave the function intact if you want to change to lowercase).
4. Press 'Enter.' Excel converts the text to the new case.
5. Copy the new data and paste it over the original cell to replace it.
6. Delete the cell with the function in it.