The PROPER function converts a text into a proper case.
In simple words, it converts a normal text case into a text in which all the letters are in lower case except the first letter of the word. For example, “EXCEL CHAMPS” or “excel champs” will be converted into “Excel Champs”.
In the below example, we have used the proper function to streamline first name and last name into the proper case.
Note: If there is a single alphabet in a cell it will convert that alphabet into a capital letter.