the PROPER function is a text function used to capitalize the first letter of each word in a text string, while converting all other letters to lowercase. This function is helpful when you want to format text so that it follows standard capitalization rules, such as making the first letter of names, titles, or sentences uppercase.
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
