Fortunately, there are several text functions in Excel to help you perform your desired tasks easily and swiftly. Today, we are going to show you how to use a text function called: PROPER. For this session, we are using Microsoft Office 365; feel free to use yours (at least 2003). In this article, I will show you how to use the PROPER function with 3 ideal examples in Excel. Hence, go through it and save your time.
Download Practice Workbook
You can download the workbook used for the demonstration from the download link below.
Introduction to PROPER Function in Excel
The PROPER function is categorized under the TEXT functions in Excel. This function capitalizes the first letter of each word in a given text string.
- Function Objective
Usually, converts a text string into the proper case; the first letter in each word to uppercase, and all other letters to lowercase.
text: The text that should be converted to proper case. However, this could be text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text.
- Returning Parameter
It returns the first letter of every word to uppercase and other letters to lowercase.
Workable from Excel version Excel 2003.
3 Ideal Examples of PROPER Function in Excel
Usually, you can use the PROPER function on various occasions. Let’s explore some common uses of PROPER. Moreover, we will be using different datasets for different examples. However, keep in mind that these are just some basic examples to demonstrate the usage of the function in different scenarios. At the same time, the usage of the function can go a long way in developing useful formulas for automation. For the purpose of demonstration, I have used three different examples.
1. Use PROPER Function to Convert String into Proper Case
From the basic description of the PROPER function, you might have understood that this function will convert the text string in such a way that the first letter of every word will be in uppercase. For example, we have introduced a dataset of several proverbs typed randomly.
However, go through the following steps to complete the task.
- Initially, select cell C5 and write down the following formula.
- Now, press Enter to get the desired output.
- Lastly, use the AutoFill tool for the entire column to apply the same formula.
2. Merge Multiple Columns in Proper Case in Excel
Furthermore, we can combine multiple columns and store them in the proper case using the PROPER function. For example, the dataset has two columns with first and last names. However, we have typed several names in different ways, and we will use the function to make them in the correct order. Hence, follow the new dataset and the steps mentioned below.
- Firstly, click on cell C5 and insert the following formula.
- Secondly, hit the Enter key to get the output.
- Finally, utilize the AutoFill tool in order to receive the complete output of the dataset.
3. Combine Excel PROPER and TRIM Functions
Last but not least, you can apply the PROPER function in order to get a proper case without unnecessary spacing. Here, I have completed the task by combining the TRIM and PROPER functions. Hence, go through the steps mentioned below in order to complete the operation easily. For the purpose of demonstration, I have used the following dataset.
- In the beginning, select cell C5 and insert the formula mentioned below.
- After that, hit Enter button.
- In the end, apply the AutoFill tool to the entire column.
- How to Use CODE Function in Excel (5 Examples)
- Use Excel EXACT Function (6 Suitable Examples)
- How to Use FIXED Function in Excel (6 Suitable Examples)
- Use CLEAN Function in Excel (10 Examples)
- How to use TRIM function in Excel (7 Examples)
- At first, you can insert the text directly using double quotations.
- Secondly, if you insert numbers into the function, then it will not be affected. The number will remain as it is.
- Thirdly, numbers in another format, such as in a currency format, may behave differently from conventional numbers. This will cause a loss of format.
- Fourthly, if your string has apostrophe s ( ‘s ), then the function will divide the word up to the apostrophe.
- Lastly, the PROPER function may not be suitable for dates.
These are all the steps you can follow to use the PROPER function in Excel. Overall, in terms of working with time, we need this function for various purposes. I have shown multiple methods with their respective examples, but there can be many other iterations depending on numerous situations. Hopefully, you can now easily create the needed adjustments. I sincerely hope you learned something and enjoyed this guide. Please let us know in the comments section below if you have any queries or recommendations.
For more information like this, visit Exceldemy.com.