PROPER Function in Microsoft Excel: Capitalize the First Letter
Command: PROPER
Syntax: =proper(cell want to amend)
Example 1: assume cell A1 = “COMPANY NAME ALPHA” (all upper case)
=proper(a1)
Result in Excel: Company Name Alpha
Easy way to capitalize first letter in each word. Similarly works if cell is all lower case.