PROPER
Capitalizes the first letter of each word.
How it’s written
PROPER(text)Example
| A | |
|---|---|
| 1 | Name |
| 2 | amara OSEI |
=PROPER(A2)Result: Amara Osei
Fixes the capitals on both names.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Check names like McDonald afterward, because it will give Mcdonald.
Practice it properly
Cleaning messy text gives you real tasks, with your formulas tested on data you haven’t seen.