Google Sheets Case Conversion – LOWER, UPPER, PROPER
Published 2026-01-28 · convertcase.in
Google Sheets offers the same case functions as Excel. Here is how to use them with practical examples.
Try it now — free instant conversion
No signup · No limits · Works on all devices
1Functions
=LOWER(A1) → lowercase =UPPER(A1) → UPPERCASE =PROPER(A1) → Title Case (every word capitalised)
2Sentence Case Workaround
No native sentence case in Sheets. Use: =UPPER(LEFT(A1,1))&LOWER(MID(A1,2,LEN(A1))) — capitalises only the first character.
Frequently Asked Questions
Is Google Sheets PROPER the same as title case?
PROPER capitalises every word including "the", "and", etc. True title case requires manual rules or a third-party tool.