PROPER is an Excel formula that is used to capitalize the first letter in a text string and any other letters in text that follow any character other than a letter. It basically converts all other letters to lowercase letters. This formula is used when we have data to be curated.
Formula: =PROPER (text)
Below is an example:
In the above example, the formula PROPER is used to capitalize the first characters of the text Akanksha Anand in the cell. In this cell, both text strings have “A” as their first character and have both been capitalized.