PROPER Function

Capitalizes the first letter of each word and makes the other letters lowercase.

PUBLISHEDApr 06, 2026

Summary

The Excel PROPER function capitalizes the first letter of each word and converts the remaining letters to lowercase. For example, =PROPER("jOHN dOE") returns "John Doe".

PROPER is useful for names, cities, titles, and other text that should follow a title-case style. It is often used after importing messy data where some rows are all caps, some are all lowercase, and some are mixed in inconsistent ways.

Purpose

Convert text to title case

Capitalizes the first letter of each word and lowers the other letters.

Return Value

A text string

Returns the same text with a more regular word-by-word capitalization pattern.

Syntax

=PROPER(text)

PROPER takes one argument: the text you want to convert. That can be a typed string or a cell reference.

Arguments

text - [Required] The text string or cell reference you want to convert to proper case.

PROPER vs Other Functions

PROPER, LOWER, and UPPER all change the capitalization of text, but they do it in different ways. Choose the one that matches the final style you need.

Function	Result	Use When
`PROPER`	John Smith	You want title case
`LOWER`	john smith	You want everything lowercase
`UPPER`	JOHN SMITH	You want everything uppercase
`TRIM`	John Smith	You also need to remove extra spaces

Using PROPER

PROPER is most helpful when the text already has the right words but the capitalization is messy. It can quickly standardize a list of names, city fields, or titles in a helper column.

It is also important to know its limits. PROPER capitalizes after spaces and other separators, so abbreviations and some special names may not come out exactly right. For example, "NY" becomes "Ny", and "McDONALD" becomes "Mcdonald".

Use PROPER when text should look like normal title case.
Check the result if the data contains abbreviations, brand names, or special name patterns.
Combine PROPER with TRIM or CLEAN when the text also needs spacing cleanup.

Example 1 - Fixing a Badly Typed Name

This is the most common use. PROPER turns uneven or random capitalization into a more standard name format.

=PROPER("jOHN dOE")      // "John Doe"
=PROPER("ALICE SMITH")   // "Alice Smith"
=PROPER("bob JONES JR")  // "Bob Jones Jr"

Check Answer

Challenge #1

Target: Sheet1!F1

Fix a Badly Capitalized Name

In cell F1, use PROPER to fix "jOHN dOE" into correct title case. Expected: "John Doe".

Example 2 - Capitalizing a City Name

City names often look better after PROPER, especially when imported from inconsistent sources. This works well as long as the field does not depend on abbreviations that should stay uppercase.

=PROPER(B2)
// "new york city" -> "New York City"

Check Answer

Challenge #2

Target: Sheet1!F2

Capitalize a City Name

In cell F2, use PROPER on B2 ("new york city") to make it "New York City".

Example 3 - Converting an ALL CAPS Product Title

PROPER can make an all-caps product title easier to read. It gives a cleaner display, even though you may still want to review special terms manually afterward.

=PROPER(A1)
// "METAL PART 001" -> "Metal Part 001"

Check Answer

Challenge #3

Target: Sheet1!F3

Fix an ALL CAPS Product Title

In cell F3, use PROPER on A1 ("METAL PART 001") to convert it to proper title case.

Example 4 - Normalizing Randomly Mixed Text

When the source text has mixed uppercase and lowercase letters, PROPER resets it to one consistent style. It is often used as the finishing step after basic cleanup.

=PROPER(C1)
// "MixEd CASE" -> "Mixed Case"

=PROPER(TRIM(CLEAN(A1)))

Check Answer

Challenge #4

Target: Sheet1!F4

Clean Mixed-Case Data

In cell F4, use PROPER on C1 ("MixEd CASE") to get consistent title case output.

One common issue is that PROPER also capitalizes letters after numbers and punctuation. That means phrases like "2nd floor" can become "2Nd Floor". For data with many exceptions, PROPER is a useful starting point, but not always the final step.

Conclusion Recap

Summary: PROPER converts text to title case.
Syntax: =PROPER(text).
Key point: It works well for ordinary names and titles, but abbreviations may need manual correction.
Practical usage: Names, cities, titles, and imported text cleanup.
Best pattern: Combine PROPER with TRIM or CLEAN when the source text is also messy.

Tactical Arena

Select Scenario:

Share PROPER Function!

Tell your friends about this post

Discussion

Select Scenario: