PROPER(text) capitalizes the first letter in each word of a text value : PROPER « Text functions « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Text functions
3. PROPER

Input the formula: =PROPER(A1)

22.16.PROPER
	22.16.1.	PROPER(text) capitalizes the first letter in each word of a text value