Proper function in Excel

Proper function  Converts all characters in a supplied text string to the proper case. A proper case means a letter that does not follow another letter is the upper case and all other characters are lower case.

Example
I am using MS excel 2016        -> Not a proper case
I Am Using Ms Excel 2016      -> A proper case


Syntax of Proper Function is

=PROPER(Text)

By using Proper finction you can capitalize each word of the string. The number and special characters are not affected.