How to change capital letters to lowercase in excel
By
SpreadCheaters
Page last updated:
18/11/2022 |
Next review date:
18/11/2024
You can watch a video tutorial here.
Text can sometimes be messy wherein some data have unwanted upper cases in them. Excel has a LOWER command which automatically turns all capital letters into lower case.
Step 1 – Click on an empty cell
Click on the empty cell and add in the formula.
Step 2 – Type in the LOWER command followed by the text you want to turn into lowercase.
In the formula bar, add in LOWER followed by the cell. In this case cell A2 is used as an example to turn all capital letters into lower text.
Step 3 – Press Enter
Pressing Enter will automatically return the output of the formula.
