Usage Of PROPER Function In Excel

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.