Text · case normalisation · Nov 2026

The UPPER function,
measured & explained.

A measured case gallery: UPPER/LOWER/PROPER on names and cities, including the apostrophe, hyphen and McDonald gotchas. Live, editable, free.

D1
fx
=UPPER(A2)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How UPPER works

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(text)
textRequired. The string (or cell) to convert to capitals. LOWER(text) and PROPER(text) take the same argument.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — Case normalisation

What UPPER / LOWER / PROPER really do

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.

Measured case gallery

ExpressionResultWhy
=UPPER(A2)ALICE SMITHForce capitals
=LOWER(A2)alice smithForce small letters
=PROPER(A2)Alice SmithCapitalise each word
=UPPER(B2)NEW YORKCity to capitals
=PROPER(B3)LondonMixed-case city tidied
=PROPER("john O'BRIEN")John O'BrienApostrophe handled
=PROPER("mary-jane")Mary-JaneHyphen handled
=LOWER(C2)hello worldNote to lower

The case trio side by side (static)

InputUPPERLOWERPROPER
alice smithALICE SMITHalice smithAlice Smith
new yorkNEW YORKnew yorkNew York
john O'BRIENJOHN O'BRIENjohn o'brienJohn O'Brien
mary-janeMARY-JANEmary-janeMary-Jane
mixed CASEMIXED CASEmixed caseMixed Case
ExpressionResultWhy
=PROPER("mcdonald")McdonaldPROPER only capitalises the first letter — not the internal C
=PROPER("they're")They'ReCapitalises after every apostrophe — usually wrong for display text
=PROPER("3rd place")3Rd PlaceCapitalises after digits too (any non-letter is a boundary)
=UPPER("abc123")ABC123Digits and punctuation pass through unchanged
⚠ PROPER is word-boundary naive. It capitalises after every apostrophe, hyphen and digit: O'BRIEN → O'Brien (good) but they're → They'Re and 3rd → 3Rd (bad). It also mangles McDonald → Mcdonald and van der Waals → Van Der Waals. Audit PROPER output for surnames and particles.
Normalise before matching: wrap lookup keys in LOWER (or UPPER) so "Alice" and "alice" align across tools. Use UPPER for canonical codes/IDs, PROPER for display names — then fix Mc/Mac, particles and apostrophe artefacts. Combine with TRIM: =TRIM(UPPER(A2)).
// 03 — Try it live

Interactive UPPER playground

Edit a name or city and watch UPPER/LOWER/PROPER respond. The static table shows the trio side by side.

A1Sample data — click any cell to edit, the formula re-evaluates live
Result
—
✓ readyHyperFormula 3.5
// 04 — Error library

The real-world error library

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.

// 05 — Cross-platform

Where UPPER works

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.

PlatformSupportNotesGotcha
✓ Supported full UPPER◐ Partial works with caveatsCompiled from public docs · verify against your build
// Go deeper

Master text cleaning

UPPER is one piece. The full course walks the toolkit end to end with live, measured examples.

  • UPPER / LOWER / PROPER — the case trio
  • PROPER's apostrophe, hyphen and digit gotchas
  • Canonical keys: TRIM + UPPER
  • Sentence case vs title case
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked