Excel Function : PROPER
Category
Text
Description
Capitalizes the first letter in each word of a text value
Microsoft Excel Reference Page
https://support.office.com/en-us/article/PROPER-function-52a5a283-e8b2-49be-8506-b2887b889f94
Syntax and Description of the PROPER Excel Function
syntax for iferror =IFERROR(value,value_if_error)
About PROPER Excel Function
The PROPER function returns a text value with the first letter in each word capitalized and all other letters in lowercase.