Basically, Proper function is a built-in function in Excel which can be considered as a string or text conversion function like Upper & Lower function. Generally, it only capitalize the first letter of a word in a given text string and the return value will be considered as proper case.
N.B. If you are unsure
about the process of UPPER & Lower function in Excel, then please check
below URL’s first, which will give you a clear concept about the working
principle of these sorts of functions.
URL:
http://www.tutorialabc.com/2020/08/upper-function-in-excel.html
URL:
http://www.tutorialabc.com/2020/09/lower-function-in-excel.html
Basic Syntax
|
=PROPER(text) |
It passes a single argument, “text” – which text will be converted to proper case.
Notes: This function can be available from Excel 2000 to up-to-date version of Excel. And, Proper function will not consider - Spaces, numbers and punctuation marks.
Example:
Let’s consider, we have a sample set of data in the worksheet.
 |
| (Working Data) |
We will get the result, by using the
PROPER function, ‘=PROPER(A1)’
Result:
James Bond
And, ‘=PROPER(A2)’
Result: Hello! World
So, to get the exact result, please take a closer look on the below screenshots and follow along with the sequence. Hopefully, it will help you to understand the PROPER function in excel properly.
 |
| (PROPER function syntax) |
 |
| (Proper Case) |
 |
| (Conditions Unaffected) |
For any query or
suggestions, feel free to contact us and stay with tutorialabc.com for more
Excel-based contents.
