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:

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

Launch **Microsoft Excel**.

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

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:

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

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