Skip to content

Excel function · Text

Excel PROPER function

PROPER capitalises the first letter of each word and lowers the rest: names typed as "emma brown" or "EMMA BROWN" become "Emma Brown".

In Turkish Excel: YAZIM.DÜZENİ

What it does

PROPER splits the text into words and capitalises the first letter of each one, lowering the rest. It treats every character that is not a letter as a word boundary, not just spaces: the letter after a hyphen, a slash or an apostrophe is capitalised too. That is why "o'neill" becomes "O'Neill", but "kate's shop" becomes "Kate'S Shop".

Abbreviations are treated as ordinary words, so "VAT" becomes "Vat" and "UK" becomes "Uk". Fix such words afterwards with SUBSTITUTE. To make all letters upper or lower case, use UPPER or LOWER.

PROPER changes only letters. Extra spaces stay where they are, so names pasted from other systems are usually cleaned with TRIM in the same formula: =PROPER(TRIM(A2)).

Syntax

English Excel=PROPER(text)
Turkish Excel=YAZIM.DÜZENİ(metin)

Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.

Arguments

ArgumentRequiredDescription
textRequiredThe text, or cell, to tidy. Characters that are not letters (spaces, hyphens, slashes, apostrophes) count as word boundaries; digits are unchanged.

Examples

1Fix names typed in mixed case

Some names were typed in lower case, others in capitals. PROPER capitalises the first letter of each word and lowers the rest.

B2fx=PROPER(A2)
Fix names typed in mixed case: example table
AB
1Name as TypedClean Name
2emma brownEmma Brown
3LUCAS GRAYLucas Gray
4ava thompsonAva Thompson
5noah CLARKNoah Clark
6olivia hughesOlivia Hughes
  • B2 (filled down to B6)=PROPER(A2)

B3 shows Lucas Gray and B5 shows Noah Clark.

We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.

2Trim and tidy district and city names

The address column also has extra spaces. TRIM cleans the spaces first and PROPER then fixes the letters; the letter after the slash is capitalised too.

B2fx=PROPER(TRIM(A2))
Trim and tidy district and city names: example table
AB
1Address as TypedClean Address
2camden / londonCamden / London
3ROUNDHAY / LEEDSRoundhay / Leeds
4 salford / manchester Salford / Manchester
5southwark / londonSouthwark / London
  • B2 (filled down to B5)=PROPER(TRIM(A2))

B2 shows Camden / London and B3 shows Roundhay / Leeds; double spaces inside are reduced to one as well.

We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.

Common errors and fixes

Capital after an apostrophe

Cause: The apostrophe counts as a word boundary, so the letter after it is capitalised: "kate's" → "Kate'S".

Fix: Fix common endings afterwards: =SUBSTITUTE(PROPER(A2),"'S ","'s "), or review those rows by hand.

Broken abbreviation

Cause: Abbreviations such as "VAT" or "LTD" are treated as words and become "Vat" and "Ltd".

Fix: Restore them with SUBSTITUTE: =SUBSTITUTE(PROPER(A2),"Vat","VAT").

Extra spaces remain

Cause: PROPER only changes letters; extra spaces between words stay.

Fix: Trim first: =PROPER(TRIM(A2)).

Good to know

  • To make the corrected names permanent, copy the results and paste them over the source column with Paste Values.
  • To capitalise only the first letter of the whole text, use =UPPER(LEFT(A2,1))&MID(A2,2,LEN(A2)) instead of PROPER.

In Nexell

Get Nexell to do it from a sentence

Type this in Nexell

Tidy the Full Name column so each word starts with a capital letter, and remove extra spaces

Convert to table

Bring your list into the tool and type this. Nexell writes the corrected names into a new column and shows them in a preview first; the source column stays as it is.

Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.

Free account · no card needed · 30 credits a month

Frequently asked questions

How do I capitalise only the first letter in Excel?

PROPER capitalises the first letter of every word. To capitalise just the first letter of the text and leave the rest alone, use =UPPER(LEFT(A2,1))&MID(A2,2,LEN(A2)).

Why does PROPER give "Mcdonald" instead of "McDonald"?

PROPER only knows word boundaries, not name rules, so it lowers every letter after the first. Names with an inner capital (McDonald, MacLeod) need a manual fix or a SUBSTITUTE afterwards.

Related functions

All text functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free