How to Change Caps to Lowercase in Excel

In this tutorial, we will teach you how to change caps to lowercase in Excel.

Many a times, a user might type in text without realizing that the entire text was written with the Caps lock turned on. The user can either re-type everything again in the lowercase or can convert the text written in caps to lowercase.


Step 1 – Enter the lower formula

Follow this step by step guide to learn how to change caps to lowercase in excel.

For the purpose of this tutorial, we will write a few lines containing all capital letters in the column A. Once you have entered the data, insert the lower formula in the cell where you want the reproduce the text written in caps into lowercase. Type in the following:

=Lower(the cell containing the capital letters)

In this manner, you can change caps to lowercase in excel.

Type in the lower formula

Step 2 – Drag the formula

You will see that the text written in the cell was copied to the one where you placed the formula. However in the transition process, the “caps” was changed to lowercase. You can now drag the formula if you want to apply it to other cells as well. In this way, you can change caps to lowercase in excel.

Apply formula to multiple cells


Step 3 – Change to capital letters

If you want to change the letters in lowercase into capital letters, type in the following formula:

=Upper(cell containing the lowercase letters)

This will change all the letters to capital.

Enter the upper formula