Excel PROPER Function

PROPER converts text to title case by capitalizing the first letter of each word.

Use it to clean imported names, labels, cities, departments, or any text where inconsistent capitalization needs a readable standard.

1
Choose text Use typed text, a cell, or a formula
2
Identify each word Spaces and separators create word starts
3
Return title case Word starts are capitalized; other letters lowercased

PROPER syntax & arguments

Syntax

=PROPER(text)
Required Optional
  1. 1

    text

    Required

    The text value, cell reference, or formula result to convert to title case.

Example

=PROPER(A2)

Convert the text in A2 so each word starts with an uppercase letter and the remaining letters are lowercase.

PROPER caveats

  • Existing capitals can be lowered

    Acronyms such as "USA" become "Usa", so PROPER is not always safe for codes or abbreviations.

  • Separators can create new word starts

    Letters after punctuation, numbers, or symbols may be capitalized because Excel treats them as new word boundaries. For example, =PROPER("sku-abc123def") returns Sku-Abc123Def.

  • It does not remove extra spaces

    PROPER keeps the same spacing as the source text. Use TRIM when imported names contain extra spaces.

  • Names may need manual rules

    Company names, brand names, and personal names with special capitalization can still require exceptions after conversion.

Need simpler case conversion? Use UPPER for all caps or LOWER for all lowercase text.

Intro PROPER practice problem

Solve the intro problem directly here, or open it on its own page.

Open full problem

Intro Name Case

PROPER
Intro ☆☆☆
Pending

Advanced PROPER practice problems

Use PROPER alongside other Excel functions in realistic, less-prescriptive challenges.

Generate User IDs

CONCATENATE LEFT RIGHT PROPER
Medium ★★☆
Pending

Name Cleanup Pro problem

PROPER TRIM
Easy ★☆☆
Pending