How to Use the LOWER Formula in Excel: Functions, Examples, and Writing Steps
Home >> Excel Tutorials from Compute Expert >> Excel Formulas List >> How to Use the LOWER Formula in Excel: Functions, Examples, and Writing Steps
In this tutorial, you will learn how to use the LOWER formula in excel completely.
When working with text in excel, we sometimes need to change the case of the text letters. LOWER is one of the excel formulas you can use to do that change process easily, besides UPPER and PROPER.
Want to know more about the formula usabilities and how to use it optimally in excel? Read this tutorial until its last part!
Disclaimer: This post may contain affiliate links from which we earn commission from qualifying purchases/actions at no additional cost for you. Learn more
Want to work faster and easier in Excel? Install and use Excel add-ins! Read this article to know the best Excel add-ins to use according to us!
Table of Contents:
What is the LOWER Formula in Excel?
LOWER is an excel formula that can help you to change all the letters case in your text into lower case.LOWER Function in Excel
You can use LOWER to lower the case in all the letters in your text.LOWER Result
The LOWER result is a text with all its letters in their lower case form.Excel Version from Which We Can Start Using LOWER
You can start using LOWER since excel 2003.The Way to Write It and Its Input
Here is the general writing form of LOWER in excel.
= LOWER ( text )
When using LOWER, you just need to input the text which letters you want to convert to lower case letters. That is the only input that LOWER needs to run its function.
Example of Its Usage and Result
Here is the implementation example of LOWER in excel.
As you can see here, we just need to input the text we want to process when we use LOWER. LOWER will immediately return to us the text with all its letters already in their lower case form!
If you input a number (or any other kind of data besides text) into LOWER, it won’t do anything into its content. However, it will change its data type to text.
Writing Steps
After we have discussed the LOWER writing form, input, and implementation example, now let’s discuss its writing steps. These steps should be quite easy to follow as LOWER only needs one input in its writing.-
Type an equal sign ( = ) in the cell where you want to put the LOWER result
-
Type LOWER (can be with large and small letters) and an open bracket sign after =
-
Input the text which letters you want to convert into their lower case form
-
Type a close bracket sign
- Press Enter
-
Done!
Exercise
After you learned how to use LOWER in excel, now let’s deepen your understanding by doing this exercise!Download the exercise file and do all of the instructions. Download the answer key file if you have done them and want to check your answers. Or probably if you are confused about how to do the instructions!
Link to the exercise file:
Download here
Instructions
Do the following three instructions by putting the answers in the gray-colored cells in the appropriate row! Use the LOWER formula to do the instructions!- Convert the letters from the name on the left to their lower case form!
- Convert the letters from the product code on the left to their lower case form!
- Write your name with capital letters as a LOWER input to try converting those letters into their lower case form!
Link to the answer key file:
Download here
Additional Note
If you input date or time data to LOWER, it will convert the data to its serial number form.Related tutorials you should learn from:
