The PROPER Function: Syntax and Examples

Proper Function

The PROPER is an Excel text function that capitalizes the first letter in each word of a text value.



Required Arguments

text: Text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text you want to partially capitalize

Proper Function Examples

This function can be used with either a cell reference or a text snippet between quotation marks. See below for examples.

Example PROPER Function With Cell Reference

Excel Capitalization Example

More Examples and Use Cases

We don’t have any use cases for this formula on our website at this moment but will link them below once we have. Stay tuned!

You can check out all the other functions available on our site at the Functions and Formulas tab.

Leave a Reply

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