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 Excel 2019, feel free to use yours (at least 2003).
You are welcome to download the practice workbook from the link below.
Excel PROPER Function
1. Basics of PROPER Function
The PROPER function is categorized under TEXT functions in Excel. This function capitalizes the first letter of each word in a given text string.
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. This could be text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text
Workable from Excel 2003.
2. Uses of PROPER Function
I. 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 world will be in uppercase.
To show you examples we have introduced a dataset of several proverbs typed randomly.
We will convert the data string into the proper case. All we need to provide is the string into PROPER. Our formula will be
Here we have inserted the Cell Reference of the first row of our table.
The string had all characters in lowercase. After using the formula, we have found the sentence in the proper case (first letter of each word in uppercase).
The strings we stored have different issues from being properly cased. The formula will eradicate all the mistypes and convert them into the proper case.
II. Combine multiple columns in proper case
We can combine multiple columns and store them into the proper case using the PROPER function.
Our example dataset has two columns having first and last names.
For example purpose, we have typed several names in different ways. We are set to combine these two columns and our formula will be
Here B4 and C4 are the Cell Reference of the first row of the First Name and Last Name column respectively.
We have used
" " to provide a space between the elements of these two columns.
The formula provided the Full Name and you can see the case of the name has been changed. Changing the cell references we will find all the full names for our dataset.
3. Quick Notes
- You can insert the text directly using double quotations.
The function will convert the first letter of each word into uppercase.
- If you insert numbers into the function,
then it will not be affected. The number will remain as it is.
3. Numbers in another format; such as in a currency format, may not behave like the conventional numbers.
This will cause the loss of format.
- If your string has apostrophe s (
's), then the function will divide the word up to the apostrophe.
The function will convert the first letter of the word and the apostrophe s into uppercase.
- PROPER may not be suitable for dates.
Providing date into the function you will get the serial number for that date.
That’s all for today. We have tried showing how you can use the PROPER function. You can use the function to capitalize the first letter of each word in a given text string. Hope you will find this helpful.
Feel free to comment if anything seems difficult to understand. Let us know any of your PROPER function-related scenarios where you have stuck, we are ready to help.