Excel PROPER Function

What is the PROPER function in Excel?

The PROPER function is one of the TEXT functions of Excel.

It Converts a text string to proper case; the first letter in each word to uppercase, and all other letters to lowercase.

We can find this function in TEXT category of the insert function Tab.

How to use PROPER function in excel

  1. Click on an empty cell (like F5).
empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

insert function tab in excel

4. Select TEXT category.

5. Select PROPER function

6. Then select ok.

excel PROPER function

7. In the function arguments Tab you will see PROPER function.

8. Text section is the text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing text to partially capitalize.

9. You will see the results in the formula result section.

How to use PROPER function in excel

Examples of PROPER function in Excel

Examples of PROPER function in Excel

PROPER related functions

  • Use UPPER functions to convert a text string to all uppercase letters.
  • Use LOWER functions to convert all letters in a text string to lowercase.

Leave a Reply

Your email address will not be published. Required fields are marked *