Excel function PROPER

The PROPER function converts the first letter of each word to uppercase and the others to lowercase.

Select the PROPER function and then enter the cell that contains the text to be converted.

proper function

The result:

proper