How to make names in MS Excel Proper?

Proper(Text) - first letter caps


Once I had list of names in MS Excel, all are in small letters.
I want the first letter alone in the Capital letter.

Then I found PROPER() Capitalizes the first letter in a string and converts all other letters to lowercase letters.

Syntax

PROPER(Text)