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.
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:
- 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.