😟Are you struggling to clean up messy data in Excel?
👉Let’s say you have a column full of names, but they’re in ALL CAPS, and you need them in proper case (e.g., "John Doe"). Manually fixing this would take forever😢
😇Here’s a quick fix: Use the PROPER function, Just type =PROPER(A1) in a new column, and it will convert "JOHN DOE" to "John Doe." Drag the formula down to apply it to the entire column.
✅For even faster results, combine this with Flash Fill (Ctrl + E). Type the first name in the correct format, press Ctrl + E, and Excel will auto-fill the rest.😁
✅Now it’s your turn. Open Excel, try this trick, and let me know @Jsmartez how much time it saved you.
Tip of the day:👇
@learnexceltoday