The Excel PROPER function is a Text function, and its purpose is to capitalize the first letter in each word of a text. Learn how to use it.