Formula to capitalize first letter of a word?

The PROPER function in Excel capitalizes the first letter of each word in a text string. Upper case converts all to uppercase capitalize is not a function. This tool enhances text formatting consistency. Understanding PROPER aids in data presentation for professional spreadsheets.