PROPER Function in Excel converts all the supplied character strings to proper case i.e. starting letter of every word in a sentence will be in upper case and rest all other letter in a word will be in lower case.
Syntax of PROPER Function in Excel:
PROPER(text)
Where text argument is the text that you want to convert into proper case.
Example of PROPER Function in Excel:
Formula:
In all of the above examples all the characters are converted into proper case.so the result will be
Result: