Goal: Standardize the messy text: "eXceL iS aWeSoMe".
Clean up capitalization for professional reports.
Ready...
💻 Formula Structure
=UPPER(text)
- Effect: Converts ALL letters to uppercase.
- Use: Standardizing codes (e.g. "US-123").
=LOWER(text)
- Effect: Converts ALL letters to lowercase.
- Use: Standardizing emails (e.g. "john@doe.com").
=PROPER(text)
- Effect: Capitalizes the 1st letter of each word.
- Use: Names and Titles (e.g. "John Doe").
-- Select a function...
...
⚠️ Common Pitfalls
🚫 PROPER Confusion
PROPER capitalizes the letter after any non-letter character.
PROPER("mc'donald") becomes Mc'Donald (Good).
PROPER("2-way") becomes 2-Way (Good).