LOWER Excel Formula

Author Zaheer    Category Formulas     Tags ,

Overview of the LOWER function in Microsoft Excel

In MS Excel, the LOWER function changes the text case of all the character in a data into lowercase. The function has the formula, =LOWER(text/cell reference).

  • Text – the text argument refers to the original text that you want to change into lowercase. You can also type in the cell reference instead of using the actual text.

For a better understanding of the topic, here are some examples for you.

  • For example, “SHARMAINE” is contained in cell A1. You can enter this formula in cell B1, =LOWER(A1). Then, “SHARMAINE” will be converted to “sharmaine”. The result will be displayed in cell B1.
  • “sharmaine” is contained in cell A2. You can enter this formula in cell B2, =LOWER(A2). Then, the result in cell B2 will still be “sharmaine”, nothing’s changed.
  • “Sharmaine” is contained in cell A3. You can enter this formula in cell B3, =LOWER(A3). Then, “Sharmaine” will be converted into “sharmaine”. The result is displayed in cell B3.
  • “SHARMAINE 143” is contained in cell A4. You can enter this formula in cell B4, =LOWER(A4). Then “SHARMAINE 143” will be converted to “sharmaine 143”. The result is displayed in cell B4.

Those are few examples that provide you an overview of the LOWER function and the results that it returns. For you to learn more about the topic here is a detailed procedure on how to use the LOWER function in Microsoft Excel.

Instructions on How to Use the LOWER Function in Microsoft Excel

Microsoft Excel features a formula that you can employ to automatically alter the text case of data in a worksheet without rewriting the data in every cell manually. This formula provides you the option of altering the text case to formal case letters, all uppercase letters or all lowercase letters. This article focuses on changing the text case to all lowercase letters. You can change the text case by using two different ways which totally depend on the Excel version you are using. This article concentrates on Microsoft Excel 2007 and the older versions.

How to Change Text Case in Microsoft Excel 2007

  • Launch the Microsoft Excel spreadsheet.
  • Then click on the cell that is adjacent to the first data cell.
  • Use the formula for the LOWER function. Type in this formula, =LOWER(cell reference) to alter the text case to lowercase.
  • As an example, in cell B1, enter this formula, =LOWER(B1) to alter the text case to lowercase.
  • The next thing to do is to click “Home”.  Next, click “Fill” and then click “Down”. Drag down the row of adjacent cells so that you could fill them with the LOWER function formula.
  • On the newly filled row, click on the top cell. Then drag down to select the entire row.
  • Click “Home” and then click “Copy”.
  • Again, on the newly filled row, click on the first cell which contains the original data.
  • Next, click the following buttons: “Paste”, Paste Special”, “Values”, “OK”. After doing that, you will notice that the new text case will display in the original data row.
  • Then delete the row that is next to the data. Don’t forget to click “Save” to save the alterations that you have made in your worksheet.

How to Change Text Case in the Older Versions of Microsoft Excel

  • Launch the Microsoft Excel spreadsheet.
  • Next, click on the cell that is adjacent to the first data cell in the row of cells that you intend to change.
  • Then click “Insert” and click “Columns”.
  • On the newly added column, click on the first cell that is adjacent to the first cell that contains the original data.
  • To change the text case to lowercase, type in this formula, =LOWER(cell reference).
  • As an example, in cell B1, enter this formula, =LOWER(B1) to alter the text case to lowercase.
  • Again, click on the first cell of the newly added column and then select the row of adjacent cells.
  • The next thing to do is to click the following buttons: “Edit”, “Fill”, “Down”. After you have clicked the following, click “Copy”.
  • Click on the first original data cell.
  • Once again, click the following: “Edit”, “Paste Special”, “Values”, “OK”. After doing that, the data with the new text case will display in the original data row.
  • Then delete the row next to the data. Don’t forget to click “Save” to save the alterations that you have made in your worksheet.

Post comment