PROPER

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.

 
Sitemap | Privacy | Terms
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation.
Copyright 2011 ExcelHelp.com All rights reserved
More Info (+)