How to Change Caps to Lowercase in Excel

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

Don't forget to check out our site howtech.tv/ for more free how-to videos!
youtube.com/ithowtovids - our feed
facebook.com/howtechtv - join us on facebook
plus.google.com/103440382717658277879 - our group in Google+

Learn how to change caps to lowercase or vice versa with the help of a formula in Excel. Furthermore, learn how to change case in Microsoft Word as well.

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.

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.

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.