Clean up text
Fix capital letters
=PROPER(A2)How it works in Excel
- PROPER capitalizes the first letter of each word and lowers the rest.
- UPPER makes every letter a capital.
- LOWER makes every letter small.
- Names such as McDonald may need a manual fix.
The idea in general
It makes messy text follow one consistent style.
What I assumed
- The text is in A2.
Check the result on your own data before relying on it.