Capitalizes the first letter and any other letters that follow a non-letter character in a text string. Converts all other letters in the text string to lowercase letters.
Syntax
PROPER(text)
Text is text enclosed in quotation marks, a formula that returns text, or a column reference containing the text you want to partially capitalize.
Examples
| Formula | Description (Result) |
|---|---|
| =PROPER("this is a TITLE") | Proper case of string (This Is A Title) |
| =PROPER("2-cent's worth") | Proper case of string (2-Cent'S Worth) |
| =PROPER("76BudGet") | Proper case of string (76Budget) |