PROPER function

Excel PROPER Function converts text to proper case, where the first letter of each word is capitalized and all other letters are in lowercase.

Syntax

PROPER(text)

Arguments

textThe text you want to convert to proper case.

How to use

To use the PROPER function, follow these steps:

  1. Click on the cell where you want the proper case text to appear.
  2. Enter the formula =PROPER(A1), replacing “A1” with the cell reference containing the text you want to convert.
  3. Press Enter.

Examples

Let’s say you have the following text in cell A1: “hello world.”

Enter =PROPER(A1) in another cell, and it will display “Hello World.”

If you have the text “exCEL fuNCTIONs” in cell A1, entering =PROPER(A1) in another cell will yield “Excel Functions.”

Note: The PROPER function will capitalize the first letter of each word in the text and convert the remaining letters to lowercase.

Additional Information

The PROPER function is useful when you have text data that is not consistently in the proper case format, and you want to make it more readable or consistent. It’s commonly used in data cleaning and formatting tasks in Excel.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.