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:
Syntax: =PROPER(A2)
Result:
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.
