MS Excel provides us with various functions to help us customize the case of the text. Among them, the LOWER function is used to change the case of existing text to lowercase. This article will share the complete idea of how the LOWER function works in Excel independently and then with other Excel functions.
Download the Practice Workbook
LOWER Function in Excel (Quick View)
Excel LOWER Function: Syntax & Arguments
Converts all the letters in a text string to lowercase.
|Argument||Required or Optional||Value
|text||Required||Pass the text which will be converted to lowercase.|
- Numbers and punctuation characters are not affected.
- Number formatting is removed from standalone numeric values.
- All letters in the text are converted to lowercase.
How to Use the LOWER Function in Excel (6 Examples)
Example 1: Convert a Text into Lowercase Using LOWER Function
Let’s have a product list with their ID, NAME, Delivery Date, and Price. All the product’s name is in capital letters. Now our task is to convert all the products names into lowercase using the LOWER function.
Step 1: Enter the formula in cell C4 and copy it down to C15
Example 2: Convert an Alphanumeric Text into Lowercase Using LOWER Function
Let’s assume our ID for each product contains alphanumeric values. The alphabets on the IDs are in uppercase form. Now our task is to convert all the alphabets into lowercase.
Step 1: Enter the formula in cell B4 and copy it down to B15
Example 3: Create Email Address from Names Using LOWER Function
Sometimes we may need to create emails using names for any organization or group. Let’s consider we have a dataset of employees with their ID, Name, Department. Now our task is to create emails for these employees using their names.
Step 1: Enter the formula in cell E4 and copy it down up to E11
- In the parameter of this LOWER function ampersand (&) is used to concatenate formula and text.
Example 4: Using Flash Fill to Change Text into Lowercase
Excel provides the option of using flash fill which made our task easier. Let’s assume we need to convert all the names using flash fill.
Step 1: First type the first cell text in lowercase format manually
Step 2: Then go to the second cell and try to type the name. There you will get suggestions like this
Step 3: Press Enter and see the output
Example 5: Convert Dates into Lowercase Using LOWER Function
By default, the LOWER function is not capable of changing dates from upper to lower format. But this is possible using another function with this LOWER function named TEXT function. Let’s see how we can change the format of the product’s delivery date.
Step 1: Enter the formula in cell D4 and copy it down up to D15
=LOWER(TEXT(C4,"mmmm d, yyyy"))
- TEXT(C4,”mmmm d, yyyy”) this portion of the formula converts the dates of the C column into text. Where the format of the text is “mmmm d, yyyy”
- If you want to explore more about this TEXT function you can visit this link
- Lastly, the LOWER function converts the text into lowercase.
Example 6: Converting Text into Lowercase Using VBA Code
Using VBA code, we can easily make our tasks more efficient and automated. Here we will see how to use VBA code to convert any text into lowercase. We will convert all the employee names into lowercase.
Step 1: Select the names that you want to change
Step 2: Go to the Developer tab and select the Visual Basic option
Step 3: Then select Module under Insert option
Step 4: Now paste the code into the VBA window and Run the code (Shortcut F5)
Sub Lowercase() For Each Cell In Selection If Not Cell.HasFormula Then Cell.Value = LCase(Cell.Value) End If Next Cell End Sub
- For Each Cell In Selection using this, we are iterating through the selected cells.
- If Not Cell.HasFormula Then this portion is checking whether it is a selected cell or not
- Cell.Value = LCase(Cell.Value) this part converts them into lowercase using LCase function
- End If this terminates the if statement.
Step 5: Now go to the worksheet and see the output
Things to Remember
|Common Errors||When they show|
|Number Formatting Remove||Numbers, punctuation, and spaces are not affected. LOWER will convert numbers to text with number formatting removed.|
|#NAME||This will appear if you did not enter the function name properly.|
|#REF!||It will appear if a LOWER function formula is used between two different workbooks and the source workbook is closed.|
That’s it all about the LOWER function. Here I have tried to give a summary of this function and its different applications. I have shown multiple methods with their respective examples but there can be many other iterations depending on numerous situations. If you have any inquiries or feedback, please let us know in the comment section.
- How to Use CONCATENATE Function in Excel (4 Examples)
- How to Use UPPER Function in Excel (4 Examples)
- How to Use RIGHT Function in Excel (With 6 Easy Examples)
- How to Use MID Function in Excel (3 Examples)
- How to use LEFT function in Excel (4 Examples)
- How to Use LEN Function in Excel (Formula and VBA Code)