PROPER

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.