A measured case gallery: UPPER/LOWER/PROPER on names and cities, including the apostrophe, hyphen and McDonald gotchas. Live, editable, free.
UPPER/LOWER only change letters; digits and punctuation pass through. PROPER capitalises after every non-letter (apostrophes, hyphens, digits) — audit its output for names.
UPPER forces capitals, LOWER forces small letters, PROPER capitalises the first letter of each word. They are the workhorses of data cleaning — normalising names, cities and codes before matching. The gallery is measured live, including PROPER's apostrophe and hyphen behaviour. Click any row.
| Expression | Result | Why |
|---|---|---|
| =UPPER(A2) | ALICE SMITH | Force capitals |
| =LOWER(A2) | alice smith | Force small letters |
| =PROPER(A2) | Alice Smith | Capitalise each word |
| =UPPER(B2) | NEW YORK | City to capitals |
| =PROPER(B3) | London | Mixed-case city tidied |
| =PROPER("john O'BRIEN") | John O'Brien | Apostrophe handled |
| =PROPER("mary-jane") | Mary-Jane | Hyphen handled |
| =LOWER(C2) | hello world | Note to lower |
| Input | UPPER | LOWER | PROPER |
|---|---|---|---|
| alice smith | ALICE SMITH | alice smith | Alice Smith |
| new york | NEW YORK | new york | New York |
| john O'BRIEN | JOHN O'BRIEN | john o'brien | John O'Brien |
| mary-jane | MARY-JANE | mary-jane | Mary-Jane |
| mixed CASE | MIXED CASE | mixed case | Mixed Case |
| Expression | Result | Why |
|---|---|---|
| =PROPER("mcdonald") | Mcdonald | PROPER only capitalises the first letter — not the internal C |
| =PROPER("they're") | They'Re | Capitalises after every apostrophe — usually wrong for display text |
| =PROPER("3rd place") | 3Rd Place | Capitalises after digits too (any non-letter is a boundary) |
| =UPPER("abc123") | ABC123 | Digits and punctuation pass through unchanged |
Edit a name or city and watch UPPER/LOWER/PROPER respond. The static table shows the trio side by side.
10 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.
UPPER, LOWER and PROPER are universal text functions across all Excel versions, Google Sheets and LibreOffice. PROPER's word-boundary behaviour is consistent across engines.
| Platform | Support | Notes | Gotcha |
|---|
UPPER is one piece. The full course walks the toolkit end to end with live, measured examples.