What is PROPER?
Capitalizes the first letter of each word in a text string. Ideal for formatting names and titles consistently.
Syntax
=PROPER(text)
Example
Formula: =PROPER(A1)
Result: John Smith
How It Works
Converts 'john smith' or 'JOHN SMITH' to 'John Smith'. Each word's first letter is uppercase, the rest lowercase. Works with any text case.