How to Use LOWER Function in Excel (6 Easy Examples)

How to Use LOWER Function in Excel (6 Easy Examples)

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)

Overview of LOWER Function

Excel LOWER Function: Syntax & Arguments

Excel LOWER Function Syntax & Arguments

Summary

Converts all the letters in a text string to lowercase.

Syntax

=LOWER (text)

Arguments

Argument Required or Optional Value
text Required Pass the text which will be converted to lowercase.

Note: 

  • 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.

Convert a Text into Lowercase Using LOWER Function

Step 1: Enter the formula in cell C4 and copy it down to C15

=LOWER(B4)

Enter formula using LOWER function

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.

 Convert an Alphanumeric Text into Lowercase Using LOWER Function

Step 1: Enter the formula in cell B4 and copy it down to B15

=LOWER(A4)

Enter formula using LOWER function

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.

Create Email Address From Names Using LOWER Function

Step 1: Enter the formula in cell E4 and copy it down up to E11

=LOWER(B4&"."&C4&"@"&"xyz.com")

Formula Explanation

  • In the parameter of this LOWER function ampersand (&) is used to concatenate formula and text.

Enter formula using LOWER function to create email

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.

 Using Flash Fill To Change Text into Lowercase

Step 1: First type the first cell text in lowercase format manually

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

 Auto flash fill suggestion

Step 3: Press Enter and see the output

Flash fill result

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.

 Convert Dates into Lowercase Using LOWER Function

Step 1: Enter the formula in cell D4 and copy it down up to D15

=LOWER(TEXT(C4,"mmmm d, yyyy"))

Formula Explanation

  • 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.

Enter formula using TEXT and LOWER Function

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.

Converting Text into Lowercase Using VBA Code

Step 1: Select the names that you want to change

Select the names that you want to change

Step 2: Go to the Developer tab and select the Visual Basic option

Select macros option

Step 3: Then select Module under Insert option

Insert a module

Step 4: Now paste the code into the VBA window and Run the code (Shortcut F5)

RUn the vba code

Code:

Sub Lowercase()
            For Each Cell In Selection
                    If Not Cell.HasFormula Then
                            Cell.Value = LCase(Cell.Value)
                    End If
            Next Cell
    End Sub

Code Explanation

  • 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

VBA output of lowercase

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.

Conclusion

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.


Further Readings:

Md. Abdullah Al Murad

Hello! Welcome to my Profile. Currently, I am working and researching Microsoft Excel, and here I will be posting articles related to this. My last educational degree is BSc, and my program was Computer Science and Engineering from American International University-Bangladesh. I am a Computer Science graduate with a great interest in research and development. Always try to gather knowledge from various sources and try to make innovative solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo