PROPER Excel Function

The PROPER function in Excel sets the first letter in a text string as the upper case and any other letters in the text string as the lower case that follow any character other than a letter.

When we import data from external sources in the financial analysis, the PROPER function converts text into the proper case. We use the function to capitalize each word in a given string. The function does not affect numbers and punctuation. The function converts all other letters to lowercase and the first letter in uppercase.

The formula of the PROPER function in Excel is =PROPER(text).

To insert the PROPER function in Excel, we should follow the below steps;

1. Select the cell to display the output.
2. Type =PROPER( or type =P and double-click the PROPER function from the list of suggestions shown by Excel.
3. Enter the cell reference values.
4. Close the bracket and press the Enter key.

The below image shows text strings in column A. But, first, let us reset the strings using the PROPER function in Excel.



The steps to reset the string by the PROPER() in Excel are as follows:

Step 1: Select the cell where we will enter the formula and calculate the result. The selected cell, in this case, is cell B2.

Step 2: Enter the PROPER formula in cell B2. The entered value of the text argument is cell A2.

The complete formula is =PROPER(A2).



Step 3: Press Enter key.

The function has returned the result in cell B2, as shown in the following image.



Step 4: Drag the cursor to cell B5 to obtain results in other cells. 



Similarly, we can use PROPER excel function to change the format of text.

We can enable PROPER Excel function using the following steps:

1. Choose the empty cell which will contain the result.
2. Go to the Formulas tab.
3. Select the Text group.
4. Select PROPER from the drop-down menu.
5. The Function Arguments window appears.
6. Based on the number of arguments, enter the value in the Text. 
7. Select OK.