Ravindra BagaleCourses & study guides Track your progress

Excel PROPER Function

By · Last updated:

Chala mitrano — pROPER is the polite name brush. First letter of each word stands up; the rest sit down.

Fictional sample data for learning. Customer name cleanup (Nagpur salon CRM + Edinburgh hotel bookings). Mixed ₹ and £.

Purpose

Capitalise the first letter of each word and make other letters lower case — for people and city names.

Return value

Text in Proper Case.

Syntax

PROPER(text)

Arguments

ArgumentRequired?Description
textRequiredThe name or phrase to re-case.

Version

All Excel versions. LibreOffice Calc compatible.

How to use — Why → What → How

Why: Nagpur salon CSVs arrive in ALL CAPS. Edinburgh hotels get lower-case guest names. PROPER makes lists readable for front desk printouts. PROPER is for display. Schedule a five-minute manual pass for Mc/Mac/ID acronyms after every bulk PROPER. Students remember the McDonald example forever.

What: PROPER sets the first letter of each word to upper case and other letters to lower case. Words are split on spaces and some punctuation. Read every argument in the table once before you type; each one changes the answer on purpose.

How — numbered steps:

  1. Type =PROPER(A2).
  2. TRIM first if needed.
  3. Fill down.
  4. Scan for Mc/Mac/ID acronyms and fix manually.
  5. Paste values for the final guest list.

Ravindra Bagale's Tip

Friends, pROPER struggles with names like McDonald or IDAC — fix those few rows by hand after.

Ravindra Bagale's Tip

Friends, sleep on PROPER and rebuild example 1 tomorrow without looking. That five-minute test beats rereading the whole page.

Ravindra Bagale's Tip

Friends, after you finish PROPER, open yesterday’s real workbook and find one place this function would have saved ten minutes. That habit turns lessons into salary skills.

Download practice file: practice-proper.xlsx (includes sheet About this data, practice sheets, and Answers).

Worked examples

1) ALL CAPS name

Nagpur salon.

RawCity
NEHA SHAHNAGPUR
OMAR KHANNAGPUR
Formula: =PROPER(A2)

Result: Neha Shah

What it means: Readable name.

2) lower name

Edinburgh hotel.

Guest
priya desai
john smith
Formula: =PROPER(A2)

Result: Priya Desai

What it means: Proper case.

3) City

Both columns.

City
nagpur
EDINBURGH
Formula: =PROPER(A2)

Result: Nagpur

What it means: City cleaned.

4) With TRIM

Spaces.

Raw
ravi bagale
Formula: =PROPER(TRIM(A2))

Result: Ravi Bagale

What it means: Trim then proper.

5) Hyphenated

Double surname.

Name
anna-marie cole
Formula: =PROPER(A2)

Result: Anna-Marie Cole

What it means: Each part capitalised.

6) Acronym caution

IDAC stays odd.

Org
idac pune
Formula: =PROPER(A2)

Result: Idac Pune

What it means: May need manual IDAC fix.

About this data. Small demo rows for learning. Real sheets are longer; the same formula pattern scales when columns are clean.

Common errors and fixes

McDonald → Mcdonald — PROPER lowercases the c. Fix: Fix special surnames manually.
Codes ruined — PROPER on SKUs. Fix: Use UPPER for codes, PROPER for names.

Notes and tips

  • PROPER is for display names and cities.
  • Watch Irish/Scottish prefixes and acronyms.
  • Front-desk printouts in Nagpur and Edinburgh both need readable names. Teach PROPER with a manual-fix pass for special surnames.
  • PROPER vs UPPER: UPPER shouts everything. PROPER vs LOWER: LOWER is for keys like email.
  • Fictional sample data only — practice amounts and names are made for learning.
  • After the 10 tasks, re-read the errors table once.
  • Say the business question in plain words before you type equals.
  • Keep a scrap sheet for experiments so you do not overwrite class files.
  • Fill formulas down only after the first row looks correct.
  • When two answers look possible, write both on paper then test in Excel.
  • PROPER is for display. Schedule a five-minute manual pass for Mc/Mac/ID acronyms after every bulk PROPER. Students remember the McDonald example forever.
  • Revisit the PROPER errors table after the quiz — most classroom mistakes are listed there.
  • Build one brand-new example on a blank sheet from memory before you close the laptop.
  • If a result looks wrong, check spaces with LEN and case with exact equals before changing the formula.
  • Share one tip from this page with a classmate in Marathi or Hindi — teaching locks the idea.
  • Keep currency symbols consistent inside a single report column even when practice mixes ₹ $ £ € across examples.
  • When Excel versions differ at home and in class, write the fallback formula under the modern one in a comment cell.
  • Print the revision card for PROPER and stick it near your monitor for one week of real worksheets.
  • When helping a junior, ask them to predict the result before pressing Enter — prediction builds judgement.
  • Keep a personal notebook of the one mistake you make most often with this function; review it monthly.

In real work

Front-desk printouts in Nagpur and Edinburgh both need readable names. Teach PROPER with a manual-fix pass for special surnames. PROPER is for display. Schedule a five-minute manual pass for Mc/Mac/ID acronyms after every bulk PROPER. Students remember the McDonald example forever. Classroom drill: write three brand-new PROPER formulas on a blank sheet using names from your own city — if you can invent them without the page open, you own the skill. Then break one formula on purpose (wrong case, wrong start, extra space) and watch the error; recovering from that break is half of interview readiness.

How it compares

PROPER vs UPPER: UPPER shouts everything. PROPER vs LOWER: LOWER is for keys like email.

Interview corner

PROPER on SKUs?
Usually no — UPPER.
McDonald issue?
Manual fix after PROPER.
Pair with?
TRIM.

UPPER, LOWER, TRIM

Practice tasks (10)

  1. Task 1. PROPER on NEHA SHAH.
    Hint: one argument.
  2. Task 2. PROPER on priya desai.
    Hint: lower input.
  3. Task 3. TRIM+PROPER messy ravi.
    Hint: nest.
  4. Task 4. PROPER a city NAGPUR.
    Hint: cities too.
  5. Task 5. Note McDonald problem.
    Hint: special surnames.
  6. Task 6. Fill three guest names.
    Hint: fill down.
  7. Task 7. Avoid PROPER on ACE-12 — use UPPER instead.
    Hint: codes.
  8. Task 8. Hyphenated anna-marie.
    Hint: example 5.
  9. Task 9. Paste values for printout.
    Hint: Paste Special.
  10. Task 10. One tip for front desk lists.
    Hint: readability.

Quick quiz

Q1. PROPER("NEHA SHAH") returns:
Q2. Best for:
Q3. Acronyms may need:
Q4. Pair with:
Q5. PROPER returns:

Answers: Q1=Neha Shah, Q2=People names, Q3=Manual fix, Q4=TRIM, Q5=Text (check after you try).

Revision card

Standalone card (no tip or photo strip). QR opens this lesson. Download the PNG and revise offline.

Revision card: PROPER
PROPER revision card