How to use PROPER Function in Excel?

In this tutorial, we will cover excel PROPER function details.

PROPER function capitalizes the first letter of text string and converts all other letters to the lower cases letters.

In the above table Col A, texts are in either upper cases or lower cases. After applying PROPER function, the table looks like:

Syntax of Excel PROPER Function

PROPER(text)

PROPER function takes text string as input and returns the string where first letter of all words has been capitalized and rest of the words in lower cases.

Uses of PROPER Function Excel

PROPER function is highly used for data (text) cleaning purposes. For example, you may receive a system generated list of employee names where First name and Last name in either upper cases or in lower cases or in mix of both. In this circumstance, PROPER function will be helpful to make names consistent i.e. first letter of each part of name in upper case and others are in lower case.

Something to note regarding PROPER function:

• PROPER function only capitalizes the first character of the word, other characters left unchanged
• Numbers, punctuation, special characters and spaces are affected by PROPER function
• PROPER will convert numbers to the text and number formatting removed

Lets look the following examples

Related Functions

UPPER function to make uppercase of the characters, LOWER function to make lowercase of all the characters, TRIM function to remove additional spaces beginning, middle or at the end of the text.

You may be interested:

1. Financial Dashboards
2. Sales Dashboards
3. HR Dashboards