PROPER
- Details
- Category: Formulas
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.



























