PROPER Function in Excel: Capitalise Each Word

📎 This article includes 1 downloadable practice file ↓

TextLevel: BeginnerAvailable in: Excel 2007+

In this article

1. Syntax
2. Examples
3. Example 1
4. Example 2
5. Common errors and fixes
6. PROPER in practice
7. Where you will use it
8. Worked example
9. Mistakes people make
10. Related functions
11. Continue learning

PROPER capitalises the first letter of each word; UPPER and LOWER change the whole text.

Syntax

=PROPER(text)

Argument	What it means
text	Text to change.

Examples

Example 1

=PROPER("asha VERMA")

Asha Verma.

Example 2

=UPPER(A2)

Codes in capitals: pan → PAN.

Common errors and fixes

You see	Why, and the fix
McDonald becomes Mcdonald	PROPER cannot know name rules; fix exceptions by hand or with SUBSTITUTE.

PROPER in practice

Where you will use it

• Fix names typed in all caps
• Clean city names from exports
• Title case for labels

Worked example

Text	Formula	Result
RAVI KUMAR	=PROPER(A2)	Ravi Kumar
mehta & sons	=PROPER(A3)	Mehta & Sons
new delhi	=PROPER(A4)	New Delhi

Results calculated in Excel.

Mistakes people make

Mistake	What to do instead
Brand names and acronyms	PROPER makes GST into Gst; fix exceptions with SUBSTITUTE
Mc/Mac and apostrophes	Check names like O'Brien manually

Related functions

UPPER · LOWER · TRIM

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Continue learning

All Text guides →

REGEXREPLACE Function in Excel: Find and Replace With PatternsREGEXREPLACE replaces text matching a pattern — strip every non-digit, collapse repeated spaces, mask…T Function in Excel: Keep Text, Blank Out NumbersT returns text unchanged and anything else as an empty string. Rarely needed alone,…NUMBERVALUE Function in Excel: Convert Text Numbers With Any SeparatorsNUMBERVALUE converts text to a number using separators you specify — essential for European-style…VALUE Function in Excel: Convert Text to a NumberVALUE turns text that looks like a number into a real number, so SUM…

📎 Practice files for this article

• 📗
  Practice workbook: Text & cleaning24 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.
  ⬇ XLSX · 35 KB

Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.