Use Excel PROPER Function to change a text into a proper case in which the first letter of a word will in upper case and rest of the letters are in lower case.
- text Text which you want converts to proper case.
Additional Information on Excel PROPER Function
- 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.
In the below example, a proper case has the first letter in the capital case in a word and rest of the letters are in the lower case comparing to other two cases lower case and upper case.
You can use this function where you want to streamline your text into a proper case.
In the below example, we have used the proper function to streamline first name and last name into the proper case. It will convert the first letter into a capital letter of each word which has space before it.
Even if there is a simple alphabet in a cell it will convert that alphabet into a capital letter.
To learn more about Excel PROPER Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.