Tired of messy capitalization in Excel? This quick tutorial shows you how to clean up names, addresses, and titles using two built-in tools: the PROPER function 🧠 and Flash Fill ⚡.

We’ll walk through:

• The formula: =PROPER(A2)

• How to use Ctrl + E for Flash Fill

• A side-by-side comparison for tricky cases like hyphens and abbreviations

• A pro tip for replacing your original column using Paste Special > Values 📝

✅ Great for fixing imported data, mailing lists, and name fields.
📌 Subscribe to @TryitLearnit for weekly Excel and Microsoft 365 tips!