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

FunctionWhat it doesExample
=UPPER(A2)converts the text to uppercaselorem ipsum → LOREM IPSUM
=LOWER(A2)converts the text to lowercaseLOREM IPSUM → lorem ipsum
=PROPER(A2)capitalizes the first letter of each word and lowercases the restunited states → United States

Change case in a cell or a column

  1. Click an empty cell next to your text, for example B2 when the text is in A2.
  2. Type =UPPER(A2), =LOWER(A2) or =PROPER(A2) and press Enter.
  3. 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:

  1. Select the formula cells and copy them.
  2. Select the original cells, then choose Edit › Paste special › Values only.
  3. 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:

InputStart Case / PROPERAPChicago
the lord of the ringsThe Lord Of The RingsThe Lord of the RingsThe Lord of the Rings
a tale of two citiesA Tale Of Two CitiesA Tale of Two CitiesA Tale of Two Cities
gone with the windGone With The WindGone With the WindGone 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

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.