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.

The easiest way to capitalize text in Excel is by using the PROPER function. It capitalizes the first letter of each word in a text string while converting all other letters to lowercase.

How to Convert Text to Title Case in Excel . The PROPER function comes in handy when you need title case—where the first ...