How to use the Excel PROPER function

Proper Excel function is used to make the given input in proper case, proper case means in a word the first character is in uppercase while the rest of the characters is in lower case for instance in a name of a person we use this function to make it in proper case, to use this function type =PROPER( and provide string as input.

Syntax: =PROPER(text)

The PROPER function syntax has the following arguments:

  • text – The text that should be converted to proper case.

Example: Let’s look at some Excel PROPER function examples and explore how to use the PROPER function as a worksheet function in Microsoft Excel:

proper function - How to use the Excel PROPER function

Syntax:  =PROPER(A2)

Result:

proper function in excel - How to use the Excel PROPER function

Syntax: =PROPER(A3)
Result: Marlon

Syntax: =PROPER(A4)
Result: Mayson

Syntax: =PROPER(A5)
Result: Blaze

Syntax: =PROPER(A6)
Result: Braydon

Syntax: =PROPER(A7)
Result: Kace

Note:

  • Use PROPER to capitalize each word in a given string.
  • All letters in text will be converted to lower case before the first letter in each word is capitalized.
  • Numbers and punctuation characters are not affected.

Add a Comment

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