It capitalizes the first letter of each word and converts the rest of the letters to lowercase.
The syntax of the function is the following:
PROPER(text)
text: The text you want to convert.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the PROPER function:
Insert the appropriate function in the cell A2 that changes the format on the contents of the cell A1 to title case.
Insert the appropriate function in the cell A3 that changes the format on the contents of the cell A1 to uppercase.
Insert the appropriate function in the cell A4 that changes the format on the contents of the cell A1 to lowercase.