Excel Tutorial – PROPER

The PROPER function in Microsoft Excel is a function that converts the first letter of each word in a cell to uppercase and the remaining letters to lowercase. This can be useful if you want to standardize the formatting of your data or if you want to perform case-insensitive comparisons.

To use the PROPER function, follow these steps:

1. Open your Excel workbook and navigate to the cell where you want to apply the PROPER function.
2. Type “=PROPER(” into the cell, followed by the cell reference or text that you want to convert to proper case. For example, if you want to convert the text in cell A1 to proper case, you would type “=PROPER(A1)”.
3. Press the “Enter” key to complete the formula. The cell will now display the text in proper case.

Here’s an example of how you can use the PROPER function in a formula:

=IF(PROPER(A1)=”Yes”, “Approved”, “Denied”)

In this example, the PROPER function is used to convert the text in cell A1 to proper case. The IF function then checks if the text is “Yes” (with the first letter in uppercase and the remaining letters in lowercase) and displays “Approved” if it is, or “Denied” if it is not.

You can also nest the PROPER function within other functions, such as the LEFT or RIGHT functions, to convert only a part of the text to proper case. For example:

=LEFT(PROPER(A1), 3)

This formula would convert the first 3 characters of the text in cell A1 to proper case.

I hope this tutorial has helped you understand how to use the PROPER function in Microsoft Excel.