Convert Uppercase Text to Lowercase in Microsoft Excel 2010

In this article we will learn how we can convert uppercase into lowercase text in Microsoft Excel 2010.

If you want to change the text from uppercase or improper case to lowercase, you don’t need to lot of retyping in Microsoft Excel 2010/2013. The steps are very easy to change the text into “Lower Case”.

Syntax of “LOWER” function:       =LOWER (text)

By using this formula you can change the text into “Lower” case in Microsoft Excel 2007/2010/2013. Consider the following Example to understand:

Follow below given steps:-

• Select the cell B2 and type the formula =Lower (A2) and press enter.
• The function of Lower case will convert the text into lower case in cell B2.

• To change the all text in Lower case, Copy formula by using the key “CTRL+C”, select the range B3:B7 and paste by pressing the key “CTRL+V” on your keyboard orwe can drag the formula till the last active cell.
• Select the range B2:B7 and copy the range to “Lower” function by pressing the key “CTRL+C” right click of the mouse select “Paste Special”.
• Paste Special dialog box will appear click on “Value” then click on ok to convert the formula into text.

This is the way we can convert the text into lower case by using the LOWER function in Microsoft Excel.