LOWER Function in Excel
In this tutorial, you will learn all the things about the LOWER excel formula. LOWER function in excel is useful to make all the letters in data to become noncapital.
Why do We Need to Learn LOWER Excel Formula?
In processing data on a spreadsheet, sometimes we want to make all the letters in a text to noncapital. This is needed for various things, such as modify the look of a document template for the formulation of a particular document that we want to use or maybe change the content from a group of data because we want to use the changed results version from the data for a specific purpose such as the process input of a formula.
As a simple example of the need in our work, let’s say we are creating an invitation letter document from a template that our company provides. In the company’s template, maybe all of the content use capital letters. We want to make all of them to noncapital before editing them to make it appropriate with our need in the letter document. But, of course, it will be very troublesome if we have to do it one by one to all of the content in the template.
To help you in making all of them to noncapital automatically as the need in the case example, then you can use the LOWER excel formula. LOWER function in excel will help you to make every letter in a data or text becomes noncapital. Useful for you to learn if you often deal with text data in a spreadsheet.
What is LOWER Function in Excel?
LOWER function in excel is a function with the usage objective to change all of the letters in data to noncapital. This function will not give any effect to parts of the data other than the capital letters.
Generally, this function input can be explained briefly as follows:
=LOWER(text)
Note:
text = the data which letters want to be processed
How to Use LOWER Excel Formula?
The following will explain the writing of the LOWER excel formula. This formula is easy to use because it only needs one input which is the data that you want to change all the letters inside into noncapital.
Using LOWER Function in Excel

Type equal sign ( = ) in the cell where you want to put the result in

Type LOWER (can be with large and small letters) and open bracket sign after =

Input the data or cell coordinate where the data which you want to process is after the open bracket sign. If you want to type a text data in this manually without using a cell coordinate, then do not forget to type the text between two quotes signs (“”)

Type close bracket sign
 Press Enter

The process is done!
Exercise
After learning how to use the LOWER excel formula, now is the time to deepen your understanding by doing the following 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 if you are confused about how to do the instructions.
Link of the exercise file:
Download here
Instructions
Do the following three instructions by putting the answers on the graycolored cells in the appropriate row according to the number! Use the LOWER excel formula to do all the instructions! Change the letters from the name on the left to noncapital!
 Change the letters from the product code on the left to noncapital!
 Write your name with capital letters as the input to change them into noncapital!
Link of the answer key file:
Download here
Additional Note
If you want the opposite, change all the letters into capital, then you can use the UPPER function. The writing of it is very similar to this LOWER function in excel.