Google Sheets has no Change Case button. You change case with three formulas, UPPER, LOWER and PROPER, then paste the results back as plain values.
The three case functions
| Function | What it does | Example |
|---|---|---|
=UPPER(A2) | converts the text to uppercase | lorem ipsum → LOREM IPSUM |
=LOWER(A2) | converts the text to lowercase | LOREM IPSUM → lorem ipsum |
=PROPER(A2) | capitalizes the first letter of each word and lowercases the rest | united states → United States |
Change case in a cell or a column
- Click an empty cell next to your text, for example B2 when the text is in A2.
- Type
=UPPER(A2),=LOWER(A2)or=PROPER(A2)and press Enter. - To fill the column, drag the small square at the bottom-right corner of the cell down, or use one formula for the whole range:
=ARRAYFORMULA(PROPER(A2:A)).
Replace the original text
The new column is still a formula that depends on column A. To keep only the converted text:
- Select the formula cells and copy them.
- Select the original cells, then choose Edit › Paste special › Values only.
- Delete the helper column.
What PROPER gets wrong
Google's own help page lists two limits. PROPER capitalizes every word, not the start of each sentence, so it's the wrong tool for paragraphs. And it lowercases everything after a word's first letter, so PROPER("mcLeod") returns Mcleod. The same applies to iPhone, NASA or eBay in a cell.
PROPER also isn't title case. It capitalizes the, of and a in the middle of a title, which no major style guide does:
| Input | Start Case / PROPER | AP | Chicago |
|---|---|---|---|
the lord of the rings | The Lord Of The Rings | The Lord of the Rings | The Lord of the Rings |
a tale of two cities | A Tale Of Two Cities | A Tale of Two Cities | A Tale of Two Cities |
gone with the wind | Gone With The Wind | Gone With the Wind | Gone with the Wind |
Sentence case and title case in Sheets
Sheets has no sentence-case or title-case function. For a column of titles or headlines, the practical route is to paste the column into our bulk converter, pick a style guide, and paste the result back. It handles names like iPhone and McLeod that PROPER breaks. In Excel, our Excel guide has a longer formula that fixes the small words; we've only tested it in Excel, so check its output before using it in Sheets.
Sources
- PROPER, Google Docs Editors Help
- UPPER function, Google Docs Editors Help
- LOWER, Google Docs Editors Help
Questions
How do I change text to uppercase in Google Sheets?
Use =UPPER(A2) in a new cell, or =ARRAYFORMULA(UPPER(A2:A)) for a whole column, then paste the results back with Paste special › Values only.
Does Google Sheets have a title case function?
No. PROPER capitalizes every word, including the, of and a, so it doesn't follow AP, Chicago or other style guides.
Why does PROPER change McLeod to Mcleod?
PROPER lowercases every letter after the first letter of a word. Google's help page uses this exact example.