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
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.
To convert all the texts in cells in excel into lower case, simply use the following formula:
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:
Now, let us see how the LOWER function behaves with numbers and symbols.
From the above image it is clear that the lower function does not change the numbers and symbols. They remain as it is.
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).
To create email addresses using the above first and last names, simply use the following formula:
As a result, excel would result into following output.
With this we have reached to the end of this blog. I hope you have enjoyed reading and learning it.
Thank You 🙂