![](https://xlncad.com/wp-content/uploads/2020/07/Proper-1.png)
Table of Contents
About
PROPER function in Excel, capitalizes every word of a text string.
Function Type
Text
Purpose
Convert the first letter of every word to ‘capital letter’ and other letters into ‘small letters’.
Return value
Text in proper case
Syntax
=PROPER(text)
Arguments
text – text to be converted into proper case
Example
![](https://xlncad.com/wp-content/uploads/2020/07/Proper-2-1024x293.png)
Notes
Proper function ignores numbers.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)