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 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 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 PROPER function helps to set the text in a proper format. If space is not properly given or there is 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 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 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 manually for big data it will take lots of time because it is very much difficult to go in each and every word to correct it. Here, 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.
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.
Now, we have to go on Formulas in the top ribbon and the click on Text. Below is the picture for reference:
After clicking on Text, we have lots of options or function 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 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”.
Now, we have to click on PROPER, then we will have below screen:
So, we can see in above pic that a box appears after clicking PROPER.
Now we have to put the cell address in the above blank box. It means as per formula we have to enter the Text parameter, so it is the cell address for which we want to apply PROPER function.
As per this example, the cell address is D6.
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 PROPER function:
We can look in the above picture that 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 PROPER formula manually, now we will see how to use the PROPER function by just entering the formula in the required cell.
In the above picture, we want to apply the formula in E3 for the text available in D3.
So, just type =PROPER
Now, press TAB button on the keyboard.
Below is the picture for reference:
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:
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 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 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 downloadable excel template. You can also go through our other suggested articles –