PROPER Function in Google Sheets: Examples, Pitfalls & Compatibility

=PROPER(text_to_capitalize)

text_to_capitalize (required): A text value or a cell containing the label to change.

Examples use English function names, comma argument separators and decimal points. Adapt formula separators to your workbook settings, not punctuation inside quoted text.

Use PROPER to prepare a display column from consistently lower-case or upper-case labels. Do not overwrite official organization names, stock codes or approved personal names: mechanical capitalization is not an authority on how a name should be written.

Each example is independent. Where input cells are listed, enter those values first; otherwise the formula is self-contained. Expected outputs are independently checked calculations or documented error expectations, not captured results from Google Sheets.

Example 1: Standardize a display heading

=PROPER("mEDiCal lab")

Expected result: "Medical Lab" (quoted here to make spaces and text boundaries visible).

The heading is converted into ordinary word capitalization without changing the spelling.

Example 2: Expose an acronym exception

=PROPER("DNA SAMPLE")

Expected result: "Dna Sample" (quoted here to make spaces and text boundaries visible).

The output illustrates why an acronym should be reviewed instead of automatically accepted as a corrected label.

Example 3: Prepare a location label

=PROPER(TRIM("  wEST   wING  "))

Expected result: "West Wing" (quoted here to make spaces and text boundaries visible).

The formula removes surplus ordinary spaces and then adjusts the two words. Preserve the raw import in a separate column.

Retain the original spelling in one column. Build a proposed display name in the next column, then review acronyms and names with internal capitals. Maintain a small approved-name lookup table for exceptions instead of successively nesting text substitutions. This preserves a traceable distinction between a proposed presentation change and the authoritative value.

An acronym loses its capitals. PROPER lowercases the remaining letters of each word. Use an exception list or leave the approved acronym unchanged.

Unwanted spaces are still present. Capitalization and whitespace cleanup are separate operations. Decide whether TRIM is suitable before changing spacing.

A name is capitalized incorrectly. Human names and brand names can have intentional internal capitals. Keep an editable, reviewed display field rather than declaring every formula result correct.

Google warns that name capitalization is not reliably handled by a mechanical title-case rule. In a shared contact sheet, treat the formula column as a proposal for review, not as an automatic correction of user-entered names. See the vendor reference for the current definition.

The simple Latin-letter examples have the same intended outcome in Excel and Sheets. They do not establish identical treatment of every language, combining mark, punctuation sequence or imported name.

Compare the PROPER guide for Microsoft Excel and its official documentation. Having a guide in both libraries establishes two documented references, not a certificate of identical behavior across releases, locales or file conversions.

UPPER, LOWER, TRIM, EXACT · All Google Sheets functions.

Editorial verification: Official references retrieved on 2026-10-12. The three worked cases are included in this release’s reproducible Python checking suite. It checks the stated arithmetic, calendar or text model and the expected documented error classification; it is not the Google Sheets calculation engine. No native application run, UI screenshot, maximum-size benchmark or cross-version certification is claimed. Review the editorial testing standards before relying on a formula in a critical workbook.