HomeMicrosoft OfficeExcelHow to change uppercase letters to lowercase in Microsoft Excel 2016 ?

How to change uppercase letters to lowercase in Microsoft Excel 2016 ?

Assume a scenario where you have a worksheet with the columns contains text with uppercase letters and you wish you convert to lowercase letters in Microsoft Excel 2016.

How to change uppercase letters to lowercase in Microsoft Excel 2016 ?

You can use the function “lower” to do this task.

Assume that the column A contains the text in uppercase letters as shown in the screenshot.

image

Select the cell “B1” and enter the formula =LOWER(A1).

image

Press the enter key so that the formula can be applied to the cell “B1”. Once this is done , select the cell B1 and drag the fill handle over the range of cells where you want to apply this formula.

You should immediately notice that the column B contains the lowercase characters of the corresponding cells of column A.

image

Share:

Leave a Reply

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021