LOWER Excel Function

The LOWER Excel function converts each character in a selected string into lowercase.

The formula of the LOWER function is =LOWER(text)

For example, we will convert all uppercase letters into lowercase using the LOWER form

In the table, the data is,
• Column A contains the Value.
• Column B contains the Output.



The procedure to change the case using the LOWER formula is,

Select cell B2, enter the formula =LOWER(A2), press the “Enter” key, and drag the formula from cell B2 to B3 using the fill handle.



We will get the output shown above.

We can insert the LOWER function as follows:

1. Select an empty cell for the output.
2. Type =LOWER( in the selected cell. [Alternatively, type =L or =LO and double-click the LOWER function from the list of suggestions shown by Excel.]
3. Enter the arguments as cell values or cell references and close the brackets.
4. Press the “Enter” key.

For example, we will convert all uppercase letters into lowercase using the LOWER Function.

In the table, the data is,
• Column A contains the Value.
• Column B contains the Output.



The procedure to change the case using the LOWER formula is,

Select cell B2, enter the formula =LOWER(A2), press the “Enter” key, and drag the formula from cell B2 to B3 using the fill handle.



We will get the output shown above in column B.

The LOWER function is in the “Formulas” tab and can be used as follows:

Choose an empty cell for the output → select the “Formulas” tab → go to the “Function Library” group → click the “Text” option drop-down → select the “LOWER” function, as shown below.