Windows

How to use the PROPER function in Excel

The-PROPER-Formula.png

In Microsoft Excel, the PROPER function is a Text function, and its purpose is to capitalize the first letter in each word of a text value that will remain in lowercase or convert to lowercase.

The formula for the PROPER function is PROPER(text). The syntax for the PROPER function is below:

Text: The text where the first letter should be converted to upper case (Capitalize).

How to use the PROPER function in Excel

Follow the steps below to use the PROPER Function in Excel:

  1. Launch Microsoft Excel.
  2. Create a table or use an existing table from your files.
  3. Place the formula into the cell you want to see the result.
  4. Press the Enter Key.

Launch Microsoft Excel.

Create a table or use an existing table from your files.

How to use the PROPER function in Excel

Place the formula =PROPER(A2) into the cell you want to see the result.

Press the enter key to see the result.

Drag the fill handle down to see the other results.

There are two other methods to use the PROPER function.

Method one is to click the fx button on the top left of the Excel worksheet.

An Insert Function dialog box will appear.

Inside the dialog box in the section, Select a Category, and select Text from the list box.

In the section Select a Function, choose the PROPER function from the list.

A Function Arguments dialog box will open.

Enter A2 in the Text entry box and click Ok.

Method two is to click the Formulas tab and click the Text button in the Function Library group.

Then select PROPER from the drop-down menu.

A Function Arguments dialog box will open; follow the same procedure in method 1.

Read: How to Group and Ungroup Rows and Columns in Excel

How many functions are in Excel?

In Microsoft Excel, there are 300+ functions. Functions help users to type complex formulas easier. Functions are separated into 13 groups such as, Database, Date and Time, Financial, Information, Logical, Lookup and Reference, Math and Trigonometry, Statistical, Text, Engineering, Cube, Compatibility, and Web functions.

Read: How to create and add a Checklist in Excel

What are the 4 basic functions in Excel?

The 4 Basic functions often used in Microsoft Word are below:

  1. SUM: Add its arguments.
  2. COUNT: Count how many numbers are in the list of an argument.
  3. IF: Specifies a logical test to perform.
  4. AVERAGE: Returns the average of the argument.

We hope this tutorial helps you understand how to use the PROPER function in Microsoft Excel.

Original Article