How to Use the PROPER Function in Excel (Capitalize Each Word)

How to Use the PROPER Function in Excel (Capitalize Each Word)

Excel’s PROPER function is used to capitalize the first letter of each word in a text string. This is especially useful when cleaning names or titles that are typed in all caps or lowercase.

📘 Syntax:

=PROPER(text)

✅ Example:

=PROPER("john doe")

Result: John Doe

🎯 Common Use Cases:

• Fixing names or titles that are all lowercase or uppercase
• Formatting product names or categories
• Cleaning imported data with inconsistent text styles

💡 Bonus Tip:

If you already have data in a column (say Column A), use this in Column B:

=PROPER(A2)

Then copy the results and paste as values to apply it permanently.

🛠 Combine With:

• TRIM() to remove extra spaces
• LOWER() and UPPER() for other formatting styles

For more simple Excel text cleanup hacks, follow ScriptDataInsights.