PROPER Function

The PROPER function in Excel is a text function that converts a text string to proper case, which means that the first letter of each word is capitalized and the rest of the letters are lowercase.

The syntax for the PROPER function is:


Where “text” is the text string you want to convert to proper case.

For example, if you have a cell with the text “this is a test” and you want to convert it to proper case, you would use the formula:


This would return the result “This Is A Test”.

Download the sample files: PROPER FUNCTION – Click here