---

LOWER Function

The LOWER function is used to lowercase text in a cell.

Changing the letter case of your cell values can be great when there is a lot of case inconsistency among the cell inputs or when preparing your dataset for case-sensitive usage.

It is typed =LOWER

If you want to use the function on a single cell, write:

If you want to use the function on a range of cells, write:

---

How to Use LOWER Function

To lower the text within an Excel cell, use LOWER.

Step 1) Start the LOWER function

1. Select a cell E2
2. Type =LOWER
3. Double click the LOWER command

Step 2) Define the cell

1. Select a cell (A2)
2. Hit enter

The letter case of cell A2 has been changed!

Step 3) Define the range to use the LOWER function on multiple cells

1. Select the starting cell (A2)
2. Add a colon (:)
3. Select the ending cell (B21)
4. Hit enter

---