How to Convert Uppercase to Lowercase in Excel
Published 2026-01-06 · convertcase.in
Excel has dedicated text functions for case conversion. No plugins needed. Here's how to use them with examples.
Try it now — free instant conversion
No signup · No limits · Works on all devices
1=LOWER() Function
In an empty cell, type =LOWER(A1) where A1 contains your uppercase text. Press Enter. Drag the formula down to apply to multiple rows.
2=UPPER() Function
Converts to all caps: =UPPER(A1)
3=PROPER() Function
Converts to Title/Proper Case: =PROPER(A1) — capitalises the first letter of each word.
4Paste as Values
After converting, copy the result → Paste Special → Values Only to remove the formula dependency.
5For Sentence Case in Excel
Excel has no native SENTENCECASE function. Use convertcase.in to convert, then paste back.
Frequently Asked Questions
Is there a sentence case formula in Excel?
No native one. You can use a complex nested formula or simply use convertcase.in and paste the result.
How do I bulk convert case in Excel?
Apply the LOWER/UPPER/PROPER formula to one cell, then drag it down the column to convert all rows at once.