PROPER Function - Excel
Overview
The PROPER function in Excel is a useful tool for capitalizing the first letter of each word in a text string while converting the rest of the letters to lowercase. This function formats your text in a way that follows standard capitalization rules.
Example:
=PROPER("elephant")
Syntax:
=PROPER(text)
text: This is the text string or cell reference containing the text you want to capitalize.
Example
In this example, the PROPER function takes the word “hiking” and capitalizes the first letter of the word while converting the remaining letters of the word into lowercase. The final output of the function is “Hiking”.
