How to Convert a Capital Letter to a Lowercase Letter in Excel

Co-authored by wikiHow Staff

Last Updated: June 17, 2019 Tested

This wikiHow teaches you how to pull text from any cell on an Excel spreadsheet, and convert it to lowercase letters. Microsoft Excel doesn't have a Change Case button, but you can use a basic formula to convert text to lowercase, uppercase or proper case.^{[1]
X
Research source}

Steps

1
Open the Excel spreadsheet you want to edit. Find and double-click your spreadsheet file to open it in Microsoft Excel.
2
Click an empty cell. You can insert the lowercase formula into any cell on your spreadsheet.
- The converted text will be inserted into this cell.
3
Type =LOWER(cell) into the empty cell. This formula will allow you to pull text from any cell on this spreadsheet, and convert it to lowercase letters.
- Alternatively, you can use the =PROPER(cell) formula to convert to proper case with the initials capitalized, or =UPPER(cell) to convert to uppercase.
4
Replace cell in the formula with the cell number you want to convert. Delete the "cell" text in the formula above, and enter the cell number that contains your text.
- For example, if you want to convert the text in cell B5, your formula should look like =LOWER(B5).
5
Press ↵ Enter or ⏎ Return on your keyboard. This will process your formula, and convert your text in the specified cell to lowercase letters.
- The converted text will show up in your formula cell here.
6
Hold down the small dot on the bottom-right of the convert/formula cell. Select the cell with your converted text, and hold down the tiny square on the lower-right corner of its outline.
7
Drag the cell outline upwards, downwards or sideways. This will expand the formula range, and convert all the text from the neighboring cells of your original uppercase cell.
- This will allow you to easily convert an entire column or row of data.