Description
PROPER Function capitalizes 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.
If you want to converts all uppercase letters in a text string to lowercase, please use LOWER function.
If you want to converts all lowercase letters in a text string to uppercase, please use UPPER function.
Syntax
PROPER(text)Parameters
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 capitalize.
Examples
The example may be easier to understand if you copy the example data (include header) in the following table, and paste it in cell A1 of a new Excel worksheet. If you need to, you can adjust the column widths to see all the data.
| Data | Formula | Result | Description |
|---|---|---|---|
| eXcEl 2021 biBle | =PROPER(A2) |
Excel 2021 Bible | Proper case of text string. |
| 2-cent's worth | =PROPER(A3) |
2-Cent'S Worth | Proper case of text string. |