Skip to main content

PROPER function


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.




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.


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.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>