Lesson 24 · Text
UPPER, LOWER & PROPER
Change text case in Google Sheets with UPPER, LOWER and PROPER. Fix names, codes and emails.
Fix the capitalization of the name in A2 so each word starts with a capital letter. Answer in B2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
Changing capitalization
| Formula | "maya PATEL" becomes |
|---|
=UPPER(A2) | MAYA PATEL |
=LOWER(A2) | maya patel |
=PROPER(A2) | Maya Patel |
Use PROPER for names, UPPER for codes like state abbreviations or SKUs, and LOWER for email addresses so that duplicates match.
Google Sheets has no "Change case" menu like some word processors do. These functions are the standard way.