PROPER capitalises the first letter of each word in a text string and converts all other letters to lowercase. It turns messy entries like "jOHN sMITH" into clean, presentable text such as "John Smith".
=PROPER(text)What does PROPER do?
PROPER is a text function that takes any text value and returns it with the first letter of every word in uppercase and all remaining letters in lowercase. Words are separated by spaces, punctuation, or numbers, so "new york" becomes "New York" and "o'neill" becomes "O'Neill".
Messy capitalisation is one of the most common data-quality problems in spreadsheets. Names imported from systems, pasted from emails, or typed quickly often arrive in all caps or random case. PROPER fixes that instantly, making lists, mail merges, and reports look professional without manual retyping.
Imagine you receive a customer list where every name is in uppercase, such as "JANE DOE". You need to send personalised emails that begin "Dear Jane Doe". Instead of editing each row by hand, you can add a PROPER formula next to the original data, copy it down, and have clean names ready in seconds.
When to use PROPER
- Standardising customer or employee names imported from another system.
- Cleaning up city, country, or product names before building a report.
- Preparing data for mail merge letters and email greetings.
- Fixing text that was typed in all caps by mistake.
- Creating tidy labels for charts and dashboards.
- Formatting titles and headings in a consistent style.
PROPER syntax
=PROPER(text)| Argument | Required? | What to enter |
|---|---|---|
text | Required | The text you want to capitalise. It can be a cell reference like A2, a text string in quotes like "hello world", or a formula that returns text. |
What it returns: A text string with the first letter of each word in uppercase and all other letters in lowercase.
PROPER examples
1 Basic name cleanup
This example shows the simplest use of PROPER. Column A contains names typed in random case. The goal is to produce a clean version in column C. The formula =PROPER(A2) takes the text from A2, capitalises the first letter of each word, and lowercases the rest. It returns "John Smith" for "jOHN sMITH".
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Raw Name | Department | ||
| 2 | jOHN sMITH | Sales | John Smith | |
| 3 | mARY jANE wATSON | Marketing | ||
| 4 | pETER o'NEILL | IT | ||
| 5 | lINDA dE LA CRUZ | Finance | ||
| 6 |
2 City names from a shipping list
Here the raw city names are in uppercase. You want to display them in proper case for a report. The formula =PROPER(A2) converts "NEW YORK" to "New York". Copy it down the column to clean every city name. The result is a tidy list ready for printing or sharing.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | City | Country | ||
| 2 | NEW YORK | USA | New York | |
| 3 | LOS ANGELES | USA | ||
| 4 | LONDON | UK | ||
| 5 | PARIS | FRANCE | ||
| 6 | BERLIN | GERMANY | ||
| 7 |
3 Product descriptions for a catalogue
Product names in column A are inconsistently capitalised. You need a standard format for an online catalogue. The formula =PROPER(A2) turns "wireless mouse" into "Wireless Mouse". It capitalises each word, including the second word. This gives a consistent, professional look across all products.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Product | Price | ||
| 2 | wireless mouse | 25.99 | Wireless Mouse | |
| 3 | USB-C HUB | 45.5 | ||
| 4 | laptop stand | 32 | ||
| 5 | mechanical keyboard | 89.99 | ||
| 6 |
4 Email greetings from a contact list
You are preparing a mail merge and need first names in proper case. Column A holds first names in lowercase. The formula =PROPER(A2) returns "Emma" from "emma". You can then use the result in a greeting such as "Dear Emma". This saves manual editing and ensures every recipient sees a correctly capitalised name.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | First Name | Last Name | ||
| 2 | emma | jones | Emma | |
| 3 | liam | brown | ||
| 4 | olivia | davis | ||
| 5 | noah | wilson | ||
| 6 |
5 Combining first and last names with PROPER
This example combines two columns and applies PROPER to the result. Column A has first names and column B has last names, both in lowercase. The formula =PROPER(A2&" "&B2) joins them with a space and then capitalises each word. It returns "Alice Johnson" from "alice" and "johnson". This is ideal for creating full names for ID cards or directories.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | First Name | Last Name | ||
| 2 | alice | johnson | Alice Johnson | |
| 3 | bob | smith | ||
| 4 | carol | williams | ||
| 5 | david | brown | ||
| 6 |
Common PROPER errors and how to fix them
| Error | Why it happens | How to fix it |
|---|---|---|
| #VALUE! | The text argument refers to a cell that contains an error value, such as #N/A or #DIV/0!. | Check the source cell and correct the error, or wrap the formula in IFERROR to handle it gracefully. |
| #NAME? | The function name is misspelled, for example =PROPPER(A2). | Use the correct spelling: =PROPER(A2). |
| Wrong capitalisation for acronyms | PROPER lowercases all letters after the first in each word, so "IBM" becomes "Ibm". | If you need to preserve acronyms, use a formula that checks for them or apply PROPER selectively and then correct specific entries manually. |
| Apostrophes cause unexpected results | PROPER treats an apostrophe as a word separator, so "o'neill" becomes "O'Neill" (which is usually desired), but "don't" becomes "Don'T". | For contractions, consider using a different approach or accept the limitation; you can manually correct specific cases. |
Tips for using PROPER
- Use PROPER on a copy of your data or in a helper column so you keep the original values intact.
- Combine PROPER with TRIM to remove extra spaces:
=PROPER(TRIM(A2)). - To convert the result to plain values, copy the formula cells and paste as values.
- Remember that PROPER changes all letters after the first to lowercase, so it is not suitable for text that must keep internal capitals.
- For names with prefixes like "Mc" or "Mac", you may need to correct the result manually.
Frequently asked questions
What does the PROPER function do in Excel?
PROPER capitalises the first letter of each word in a text string and converts all other letters to lowercase. For example, =PROPER("hello world") returns "Hello World".
How do I capitalise only the first letter of a cell, not every word?
Use a formula like =UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2)-1)). PROPER capitalises every word, which may not be what you want for sentences.
Does PROPER work with numbers and dates?
PROPER converts numbers and dates to text and then applies capitalisation. Since numbers have no letters, they are returned unchanged as text. Dates may be converted to their serial numbers, so use with care.
Why does PROPER turn "USA" into "Usa"?
PROPER lowercases all letters after the first in each word. Acronyms like USA are not preserved. You can manually correct such entries or use a more complex formula to handle exceptions.
Can I use PROPER on a range of cells at once?
PROPER works on a single text value. To apply it to a range, enter the formula in the first cell and copy it down, or use it inside an array formula in newer Excel versions.
Related functions
Every example on this page was recalculated by SheetSkill’s spreadsheet engine. PROPER reference