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”.
- text Text which you want converts to proper case.
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.
- It can only convert text into the proper case, any value which is not text will not change.
- It capitalizes the first letter the word that follows a non-text character. =Proper(“excel-champs”) = Excel-Champs.