Overview
Grammar | PROPER(text) | Capitalizes the first letter and letters that follow any non-letter character intexts and converts all other letters to lowercase. |
Parameter 1 | text | Formula, double-quoted text string, or referenced cell to be converted |
Notes
The function supports one text-type parameter.
Direct connect data does not support this function.
Example
| Formula | Result | Notes |
|---|---|---|
| PROPER("Finemore Integrated Office") | Finemore Integrated Office | |
| PROPER("100 percent") | 100 Percent | |
| PROPER("SpreaDSheEt") | Spreadsheet |
Previous：REGEXP - Determining Whether a Character String Matches a Regular Expression
