In this, article we will learn about LOWER function in Microsoft Excel.
LOWER function converts all letters from uppercase (capital letters) to lowercase in a text string.
Let’s take a look at few examples and understand how to use this function in Excel.
1st Example:-
In this example, we will see how LOWER function works. We have taken all the characters in capital letters.
Follow the steps given below:-
The function has converted all the characters into small letters.
Note: The function takes only single argument which is a text argument, and it can either be a cell reference to the location in the worksheet or supplied directly to the argument. The argument is required for function to perform the action.
2nd Example:-
In this example, we have a cell with text in mixed letters. Now what will happen if we use LOWER function?
Follow the steps given below:-
The function has converted all the letters into small case and returns text string as “this is sample text”.
3rd Example:-
In this example, we will see how function responds, if the text string is already in lower case.
Follow the steps given below:-
The function would not do nothing anything and return to the original text string because it is already in lower case.
4th Example:-
Follow the steps given below:-
It has changed only uppercase letters and converted them to lowercase. However, the numbers and special characters remain unaffected. Thus, we can say LOWER function does not affect numbers or special characters.
5th Example:-
In this example, we have taken #N/A error in the argument and we’ll see what function would return to?
Follow the steps given below:-
The function has returned #N/A error which we have taken in the argument. That’s because function would look only for text value, and when it found error value in it, it returned the same error as result.
So, this is how LOWER function can be used in different situations in Excel.
Click on the video link for quick reference to the use of LOWER function. Subscribe to our new channel and keep learning with us!
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
