Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
This article describes the formula syntax and usage of the PROPER function.
Description
Capitalises the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.
Syntax
PROPER(text)
The PROPER function syntax has the following arguments:
- text - Required. Text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text you want to partially capitalise.
Example
| Formula | Description | Result |
| =PROPER({variable}) | Proper case of the variable (assuming the variable has a value of "this is a TITLE"). | This Is A Title |
| =PROPER(2-way street) | Proper case of the string. | 2-Way Street |
| =PROPER(76BudGet) | Proper case of the string. | 76Budget |
Errors
For a full list of formula errors, please read Formula errors.