The PROPER function in Microsoft Excel is used to capitalize the first letter of each word in a given text string. It converts the rest of the letters in each word to lowercase. This function is especially useful for formatting names, titles, or any text where proper capitalization is required.
Syntax
=PROPER(text)
text: This is the text string that you want to convert to title case (capitalize the first letter of each word). It can be a reference to a cell containing text or a text string enclosed in double quotation marks.
Example
