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.