Functions
PROPER
Capitalize first letter of each word
Try it
When to use it
When should I use PROPER instead of UPPER or LOWER?
Use PROPER to capitalize the first letter of each word and lowercase the rest; use UPPER or LOWER when you want every letter in a single case.
Does PROPER fix inconsistent capitalization in names?
Yes — PROPER normalizes mixed-case text so each word starts with a capital letter, which is handy for cleaning up name and address columns.
Use cases
Title-case a lowercase phrase
Capitalize a street address
Used in
Syntax
PROPER(text)