How to convert Capital Letters to Small letters in Excel Sheet

In this post I am going to explain how to convert text from Capital letter to small letter using built in Excel function LOWER and same is vice versa for the Small to Capital letter using the function UPPER. Like Microsoft WORD we dont have function in EXCEL to changing capitalization.We can use the UPPER and LOWER functions to automatically change the case of existing text to uppercase and lowercase. In Excel we have another function called PROPER which capitalizes only the first letter in each name.

Excel convertion from capital to small letter is explain below with the screen shots

In the below example we have two columns 1. CUSTOMER Names 2. Sample Codes.

To convert from Capital to Small letter first we hvave to insert a temporary column next to the column that contains the text you want to convert. Here we have added a new column B to the right of the CUSTOMER Names column. Please find the screen shot below in which the new column B is marked with green color.

Now move your curson in cell B2 and type the function =LOWER(A2) and then press Enter. Please find the screen shot below with the function typed in the column B2.

Now the column B2 the text is converted into Small letters. Now we can apply the same to other values by dragging the small black square that appears in the lower-right corner of the cell or the quickest way to do this is by selecting cell B2 and then double-click the small black square that appears in the lower-right corner of the cell. Please find the screen shot below for the same.

Now the values are converted into small letters. Please find the screen shot below

Now we can use this small letter and copy it to the required columns. Here when we copy to required columns then formulas also copied to column. So to avoid formulas and have only values we have to select the Option Only values in the Paste option. Please find the screen shot below.

Note: The process is same if we want to convert from Small letters to Capital Letter by using the Function UPPER.
You can also we the same in my youtube channel link
How to convert Capital Letters to Small letters in Excel Sheet