The PROPER is an Excel text function that capitalizes the first letter in each word of a text value.
Syntax
PROPER(text)
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.
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.