PROPER function is used to capitalize each starting letter of a text string while ignoring numbers and punctuation.
text in parenthesis is a reference to a cell, which contains a text string to whom you want to capitalize.
To utilize PROPER function, do following simple steps:
2. After pressing enter, Excel will capitalize each starting letter of the sentence.