PROPER Function in Excel (Table of Contents)
PROPER in Excel
Proper function in excel is used when we have a string of text or a sentence, and that is not in a proper format. Using the Proper function here will convert that text into a proper case in which every word’s first letter will be in CAPS or Upper case, and the rest of the letter will be in Lower case. This function considers only text as an input. For example, we have a text as “this is a bat”, then using a proper function, it will change its format as “This Is A Bat.”
It is a built-in function of Microsoft Excel.
We can refer above picture to know that where a PROPER in Excel is exactly located. Firstly, we have to go to Formulas, and under this head, we have to click on PROPER.
So, we can say that the PROPER function helps to set the text in a proper format. If space is not properly given or there is an unnecessary blank, in that case, also PROPER function helps. The PROPER function also helps or can be used to set in UPPERCASE each word in a given string.
PROPER Formula in Excel:
Below is the PROPER Formula in Excel:
Text: In the PROPER function, there is only one parameter which text, we can define it as it is the cell address for which PROPER function will be used and converted into the first character in uppercase and rest in lowercase for each word.
It is very much easy to use and used where the text is messed up due to many reasons.
How to Use PROPER Function in Excel?
PROPER in Excel is very simple to use. Let us now see how to use a PROPER function in Excel with the help of some examples.
We can take an example of the above one where we can see the Text is not a proper format; the uppercase and lowercase are mixed, which is wrong. So, if we do it manually for big data, it will take lots of time because it is very difficult to go into each word to correct it. Here, the PROPER function helps to arrange the case in the proper format.
We have two options to do it, i.e. 1) we can do it manually by clicking the PROPER function 2) we can also put a formula in the required cell. We will see it one by one.
Step1: Click on the cell where we require the proper text.
So, in the above example, we want the proper data in the cell address E6, hence clicked on this cell. We can see that it is highlighted in red.
Step 2: Now, we have to go on Formulas in the top ribbon and then click on Text. Below is the picture for reference:
Step 3: After clicking on Text, we have lots of options or functions to use, then we will look for PROPER, which is required here and click on that PROPER function. Below is the picture:
After moving to PROPER, we can see that the description of the PROPER function is also given in the box, which says that “converts a text string to a proper case; the first letter in each word to uppercase, and all other letters to lowercase”.
Step 4: Now, we have to click on PROPER, then we will have the below screen:
So, we can see in the above pic that a box appears after clicking PROPER.
Step 5: Now, we have to put the cell address in the above blank box. It means, as per the formula, we have to enter the Text parameter, so it is the cell address for which we want to apply the PROPER function.
As per this example, the cell address is D6.
Step 6: At last, we have to hit the Enter button or click on OK to apply the PROPER function in the given cell address. Below is the picture for reference:
After clicking OK, we will have the result for the PROPER function:
We can look in the above picture that the PROPER function is applied on the D6, and we have the result in the cell address E6. So, in E6, the text is written in a proper format. We can see the first letter of each word is in uppercase, and the rest is in lowercase.
We can drag the formula or copy-paste the formula in the required cell.
We have seen in the above example that how to apply the PROPER formula manually; now, we will see how to use the PROPER function by just entering the formula in the required cell.
Step 1: In the above picture, we want to apply the formula in E3 for the text available in D3.
So, just type =PROPER.
Step 2: Now, press the TAB button on the keyboard.
Below is the picture for reference:
Step 3: Now, we can see that it is asking for the compulsory parameter, which is text, so we can enter the cell address for which we have to apply the PROPER function. In this case, the cell address is D3. So, we will select the cell address manually or by typing the cell address. Below is the picture:
Step 4: Now, we have to close the formula by entering ” ) “ or simply hitting Enter on the keyboard.
We have the below result:
Things to Remember
- The proper function always converts the ‘s to S, so it considers as the first letter.
The Result will be:
We can see in the above pic that after using the PROPER function, it is Excel’S Formula and the raw data in the cell address is Excel formula. So, we have the proper text with the character in Uppercase and rest in lowercase. So, always take care of that and convert it manually if required if “ ‘ “is available.
- A PROPER function does affect the numbers and punctuations available in the string in which the formula is applied.
This has been a guide to PROPER in Excel. Here we discuss the PROPER Formula and how to use the PROPER function in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –