Spreadsheet Practice

PROPER function

Quick answer

PROPER capitalizes the first letter of each word and lowercases the rest.

Syntax
=PROPER(text)
Most common use
=PROPER(A2) returns Maya Chen (An all-caps name in name case)

It cleans up names, cities and titles typed in all caps or all lowercase, though it needs help with names like McDonald and small words like "of".

Available in
Every current version
Category
Text functions
Returns
Text with the first letter of each word capitalized.

Syntax

=PROPER(text)

ArgumentRequired?What it is
textRequiredThe text or cell to convert.

Examples

Each result below is calculated from the sample sheet by our formula engine, the same one that grades the practice.

CellFormulaResultWhat it shows
D2=PROPER(A2)Maya ChenAn all-caps name in name case
D3=PROPER(B3)New YorkA city in title case
D4=PROPER(C4)Head Of SalesSmall words get a capital too: "Of"

Try it live

This is the sample sheet. Change any number or text, or edit a formula, and the results update.

Show the sample data as a table
NameCityTitleResult
MAYA CHENst. paulvp, financeMaya Chen
raj patelNEW YORKsales leadNew York
liam o'brieneden prairiehead of SALESHead Of Sales

Practice PROPER

From lesson 20, Cleaning messy data. Graded instantly, then re-checked on changed data.

Clean names

In B2, remove extra spaces and convert to Proper Case. Fill down to B6.

Common mistakes

What you seeWhy, and how to fix it
Mc and Mac namesPROPER turns MCDONALD into Mcdonald. Fix exceptions afterward with SUBSTITUTE, or by hand.
Small words capitalized"head of sales" becomes "Head Of Sales". Lowercase them again with SUBSTITUTE: =SUBSTITUTE(PROPER(A2)," Of "," of ").
Acronyms lose their capitalsPROPER turns "IBM partner" into "Ibm Partner". Keep acronyms in their own column or restore them with SUBSTITUTE.

Tips

  • Clean spacing and case in one step with =PROPER(TRIM(A2)).
  • PROPER also capitalizes after an apostrophe or hyphen, so o'brien-smith becomes O'Brien-Smith.

Questions

How do I capitalize the first letter of each word in Excel?

Use =PROPER(A2). It capitalizes every word and lowercases the rest of each word.

How do I capitalize only the first letter of a sentence?

Combine UPPER, LOWER, LEFT and MID: =UPPER(LEFT(A2,1))&LOWER(MID(A2,2,999)).

Lessons that use PROPER

Answers that use PROPER

In other languages

PROPER is NOMPROPIO in Spanish Excel and GROSS2 in German Excel. Each page has the syntax with semicolons, the examples and the exercise in that language. For other functions and languages, use the Function Translator.

Updated Checked by running: every formula on this page was run by our formula engine on .