Excel Function: PROPER
The Excel function PROPER capitalizes the first letter of each word and changes all other letters to lowercase.
Usage:
=PROPER(text)
Example of use
Select the PROPER function and simply enter the text to convert:
The result after copy: