Text · Nov 16, 2026

The PROPER function,
measured & explained.

PROPER converts text to title case: the first letter of each word becomes uppercase and every other letter lowercase. Any non-letter starts a new word, so spaces, hyphens, apostrophes and digits all trigger capitalization — great for names, surprising for McDonald or it's.

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

How PROPER works

Returns text. The first letter after any non-letter is uppercased; all other letters are lowercased.

=PROPER(text)
textThe text or cell reference to convert to title case.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — Word boundaries

Where PROPER capitalizes

A word boundary is any non-letter. Measured live. Click any row to load it.

Boundary rule, measured

ExpressionResultWhy
=PROPER(A2)Alice SmithAlready proper, unchanged
=PROPER(C2)New YorkCity to title case
=PROPER(A3)Bob JonesUppercase name normalized
=PROPER(C5)ChicagoMixed case normalized
=PROPER("jOHN mCdonald")John McdonaldInternal capitals lost
=PROPER("hello-world")Hello-WorldHyphen boundary
=PROPER("it's a test")It'S A TestApostrophe boundary trap
=PROPER("123 main st")123 Main StDigit boundary
⚠ Apostrophes are boundaries: PROPER("it's") returns "It'S". Internal capitals are lost: mCdonald becomes Mcdonald. Fix known exceptions after conversion.
PROPER lowercases every letter that is not first in a word, so it destroys intentional capitals like McDonald or iPhone.
// 03 — Try it live

Interactive PROPER playground

Edit the table or type any formula — the engine evaluates instantly. Load a preset to see title case and its boundary traps.

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

The real-world error library

8 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 PROPER works

PROPER is a core text function present in every Excel version and platform.

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

Master text

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

  • Word boundary = any non-letter
  • Apostrophe and hyphen traps
  • Internal capitals destroyed
  • Use for display names, not keys
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked