Excel LOWER Function – Convert Letters In Lower Case

Many a time, while working with texts in excel, you may get the sentence in capital letters or not in a proper case. In that case, you may want to convert the characters/letters in a sentence into lower case (i.e. non-capital). This is very easy to achieve in excel by using the LOWER excel function.

Let us deep-dive into how to use the LOWER formula in excel.

At the end of this blog, I would also show you how did I practically use the LOWER excel formula to achieve my excel task.

Here we go 😎

When To Use LOWER Function in Excel

The excel LOWER function converts and returns all the letters and characters in a text string into lower case. It is important to understand the below points:

  • The LOWER function converts all the capital letters in a sentence into non-capital form.
  • It keeps the lower case letters as it is.
  • Also, the non-text strings, like numbers, symbols, etc. will also remain unimpacted.

The LOWER Function forms part of the TEXT function group, therefore the result of this function is a text formatted string.

Syntax and Argument

=LOWER(text)

The LOWER function consist of a single argument, viz. text.

  • text – It is a mandatory argument. In this argument, specify the text string to convert to lower case. You can either manually enter this argument (within double quotes) or use a cell’s reference.

LOWER Function Examples

In this section of the blog, let us unlock how does the LOWER function work in excel with the help of an example.

Look at the texts in column A in the below image.

Convert All Letters into Lower Case - Example

To convert all the texts in cells in excel into lower case, simply use the following formula:

=LOWER(A2)

As a result, excel would convert the text ‘Excel’ into ‘excel’ (all letters in lower case). Similarly, the text ‘EXCEL’ will also become ‘excel’. See the image below:

LOWER Function in Excel

Now, let us see how the LOWER function behaves with numbers and symbols.

Numbers and Symbols in LOWER Function

From the above image it is clear that the lower function does not change the numbers and symbols. They remain as it is.

Infographic - LOWER Formula Function in Excel

Practical Usage of LOWER Excel Function

Now, when you have a clear understanding about the LOWER function, let us look at some practical aspect of it.

I have used this trick a lot in my daily excel tasks 😉

The LOWER function is very useful when you want to generate email addresses in excel using the first and last names (in capital letters).

First Name and Last Names in excel

To create email addresses using the above first and last names, simply use the following formula:

=LOWER(A2&"."&B2&"@xyz.com")

As a result, excel would result into following output.

Generate Email Addresses in Excel

With this we have reached to the end of this blog. I hope you have enjoyed reading and learning it.

Thank You 🙂

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.