The Excel PROPER function converts text into proper case by capitalizing the first letter of each word and converting all remaining letters to lowercase. This is especially useful when cleaning up names, addresses, product descriptions, or any imported data that contains inconsistent capitalization.
For example, if a customer list contains names entered as “JOHN SMITH” or “jane doe”, the PROPER function can automatically convert them to “John Smith” and “Jane Doe” without manual editing.
In This Guide, You’ll Learn
- What the PROPER function does
- The syntax and arguments of PROPER
- How to convert text to proper case
- Practical examples using names and business data
- Common mistakes when using PROPER
- Real-world uses for data cleaning and formatting
What is the PROPER Function?
The PROPER function converts text into proper case by capitalizing the first letter of each word and changing all other letters to lowercase.
It is commonly used when importing data from external systems with inconsistent text formatting.
PROPER Function Syntax
=PROPER(text)Argument Definitions
- text – The text string you want to convert to proper case. This can be text entered directly into the formula or a cell reference containing text.
Example Dataset Used in This Tutorial
You can download the sample data we’ll be using in this tutorial by clicking on this link—> PROPER Function Data
Convert a Name to Proper Case
Suppose a customer’s name was entered entirely in uppercase letters.
Formulas Used
=PROPER(A2)=PROPER(A3)=PROPER(A4)
How This Formula Works
- Excel converts the first letter of each word to uppercase while converting all remaining letters to lowercase
Fix Names Entered in Lowercase
Many imported datasets contain names in all lowercase letters.
Formulas Used
=PROPER(A2)=PROPER(A3)=PROPER(A4)
How This Formula Works
- Excel converts the first letter of each word to uppercase while converting all remaining letters to lowercase
Clean Address Data
Addresses often arrive with inconsistent capitalization.
Formulas Used
=PROPER(A2)=PROPER(A3)=PROPER(A4)
How This Formula Works
- Excel converts the first letter of each word to uppercase while converting all remaining letters to lowercase
Important Things to Know About PROPER
Numbers Are Not Changed
PROPER only affects text. The numbers remain unchanged.
PROPER Capitalizes After Spaces and Symbols
Excel treats spaces and many punctuation marks as word separators.
Acronyms May Not Appear Correctly
One limitation of PROPER is that it converts all letters after the first lowercase letter.
You may need additional formulas if acronyms must remain uppercase.
Common PROPER Mistakes
Using PROPER When You Need All Uppercase
If you want all text uppercase, use:
=UPPER(A2)Using PROPER When You Need All Lowercase
If you want all text lowercase, use:
=LOWER(A2)Expecting Acronyms to Stay Uppercase
PROPER converts:
USAto:
UsaThis behavior is normal and often requires manual correction or additional formulas.
Example Dataset Used in This Tutorial
You can download the sample data we’ll be using in this tutorial by clicking on this link—> PROPER Function Data
