EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources TEXT and String Functions in Excel PROPER Function in Excel
Secondary Sidebar
Excel Functions
  • TEXT and String Functions in Excel
    • Excel CODE Function
    • Excel Find
    • TRIM Formula in Excel
    • Excel CHAR Function
    • LEFT Formula in Excel
    • Opposite of Concatenate in Excel
    • Concatenate Strings in Excel
    • Extract Numbers From String
    • VALUE Formula in Excel
    • Left TRIM in Excel
    • Substring Excel Function
    • SUBSTITUTE Function in Excel
    • Excel VALUE Function
    • Excel REPT Function
    • Excel TRIM Function
    • Excel CLEAN Function
    • Excel EXACT Function
    • PROPER Function in Excel
    • Excel LEFT Function
    • MID Function in Excel
    • LEN Function in Excel
    • CONCATENATE Function in Excel
    • SEARCH Function in Excel
    • RIGHT Function in Excel
    • FIND Function in Excel
    • TEXT Function in Excel
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Online COURSE
  • Online Excel Data Analysis Training

PROPER Function in Excel

By Madhuri ThakurMadhuri Thakur

PROPER in Excel

PROPER Function in Excel (Table of Contents)

  • PROPER in Excel
  • How to Use PROPER Function in Excel?

PROPER in Excel

Proper function in excel is used when we have a string of text or a sentence, and that is not in a proper format. Using the Proper function here will convert that text into a proper case in which every word’s first letter will be in CAPS or Upper case, and the rest of the letter will be in Lower case. This function considers only text as an input. For example, we have a text as “this is a bat”, then using a proper function, it will change its format as “This Is A Bat.”

It is a built-in function of Microsoft Excel.

PROPER Function steps

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

We can refer above picture to know that where a PROPER in Excel is exactly located. Firstly, we have to go to Formulas, and under this head, we have to click on PROPER.

So, we can say that the PROPER function helps to set the text in a proper format. If space is not properly given or there is an unnecessary blank, in that case, also PROPER function helps. The PROPER function also helps or can be used to set in UPPERCASE each word in a given string.

PROPER Formula in Excel:

Below is the PROPER Formula in Excel:

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,768 ratings)

PROPER Formula in Excel

Compulsory Parameter:

Text: In the PROPER function, there is only one parameter which text, we can define it as it is the cell address for which PROPER function will be used and converted into the first character in uppercase and rest in lowercase for each word.

It is very much easy to use and used where the text is messed up due to many reasons.

How to Use PROPER Function in Excel?

PROPER in Excel is very simple to use. Let us now see how to use a PROPER function in Excel with the help of some examples.

You can download this PROPER Function Excel Template here – PROPER Function Excel Template

Example #1

Example 1

We can take an example of the above one where we can see the Text is not a proper format; the uppercase and lowercase are mixed, which is wrong. So, if we do it manually for big data, it will take lots of time because it is very difficult to go into each word to correct it. Here, the PROPER function helps to arrange the case in the proper format.

We have two options to do it, i.e. 1) we can do it manually by clicking the PROPER function 2) we can also put a formula in the required cell. We will see it one by one.

Step1: Click on the cell where we require the proper text.

PROPER Example 1-2

So, in the above example, we want the proper data in the cell address E6, hence clicked on this cell. We can see that it is highlighted in red.

Step 2: Now, we have to go on Formulas in the top ribbon and then click on Text. Below is the picture for reference:

PROPER Example 1-3

Step 3: After clicking on Text, we have lots of options or functions to use, then we will look for PROPER, which is required here and click on that PROPER function. Below is the picture:

PROPER Example 1-4

After moving to PROPER, we can see that the description of the PROPER function is also given in the box, which says that “converts a text string to a proper case; the first letter in each word to uppercase, and all other letters to lowercase”.

Step 4: Now, we have to click on PROPER, then we will have the below screen:

PROPER Example 1-5

So, we can see in the above pic that a box appears after clicking PROPER.

Step 5: Now, we have to put the cell address in the above blank box. It means, as per the formula, we have to enter the Text parameter, so it is the cell address for which we want to apply the PROPER function.

As per this example, the cell address is D6.

PROPER Example 1-6

Step 6: At last, we have to hit the Enter button or click on OK to apply the PROPER function in the given cell address. Below is the picture for reference:

PROPER Example 1-7

After clicking OK, we will have the result for the PROPER function:

PROPER Example 1-8

We can look in the above picture that the PROPER function is applied on the D6, and we have the result in the cell address E6. So, in E6, the text is written in a proper format. We can see the first letter of each word is in uppercase, and the rest is in lowercase.

We can drag the formula or copy-paste the formula in the required cell.

Result of Example 1

Example #2

We have seen in the above example that how to apply the PROPER formula manually; now, we will see how to use the PROPER function by just entering the formula in the required cell.

Example 2

Step 1: In the above picture, we want to apply the formula in E3 for the text available in D3.

So, just type =PROPER.

PROPER Example 2-2

Step 2: Now, press the TAB button on the keyboard.

Below is the picture for reference:

PROPER Example 2-3

Step 3: Now, we can see that it is asking for the compulsory parameter, which is text, so we can enter the cell address for which we have to apply the PROPER function. In this case, the cell address is D3. So, we will select the cell address manually or by typing the cell address. Below is the picture:

PROPER Example 2-4

Step 4: Now, we have to close the formula by entering ” ) “ or simply hitting Enter on the keyboard.

PROPER Example 2-5

We have the below result:

Result of Example 2

Things to Remember

  • The proper function always converts the ‘s to S, so it considers as the first letter.

Things to Remember 1

The Result will be:

Things to Remember 2

We can see in the above pic that after using the PROPER function, it is Excel’S Formula and the raw data in the cell address is Excel formula. So, we have the proper text with the character in Uppercase and rest in lowercase. So, always take care of that and convert it manually if required if “ ‘ “is available.

  • A PROPER function does affect the numbers and punctuations available in the string in which the formula is applied.

Recommended Articles

This has been a guide to PROPER in Excel. Here we discuss the PROPER Formula and how to use the PROPER function in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. TRUE Function in Excel
  2. RATE Function in Excel
  3. MID Function in Excel
  4. PROPER Function in Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Data Analysis Training (17 Courses, 8+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download PROPER Function Excel Template

EDUCBA

Download PROPER Function Excel Template

EDUCBA

डाउनलोड PROPER Function Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more