• Skip to primary navigation
  • Skip to main content
  • Skip to footer
WallStreetMojo

Wallstreet Mojo

Wallstreet Mojo

MENUMENU
  • Resources
        • Excel

          • Excel Functions
          • Excel Tools
          • Excel Tips
        • Excel
        • Financial Functions Excel

          • NPV in Excel
          • IRR in excel
          • PV in Excel
        • Financial-Functions-Excel
        • Lookup Functions Excel

          • VLOOKUP
          • HLOOKUP
          • Index Function
        • Lookup-Functions-in-Excel
        • Excel Charts

          • Pareto Chart in Excel
          • Gannt Chart in Excel
          • Waterfall Chart in Excel
        • Excel-Charts
        • VBA

          • VBA Left Function
          • VBA Paste Special
          • VBA Worksheet Function
        • VBA
        • Others

          • Resources (A to Z)
          • Financial Modeling
          • Equity Research
          • Private Equity
          • Corporate Finance
          • Financial Statement Analysis
  • Free Courses
  • All Courses
        • Certification Courses

          Excel Course certificate
        • Excel VBA All in One Bundle

          Excel-VBA-Certification-Course
        • Excel Data Analysis Course

          Excel-Data-Analysis-Course
        • VBA Macros Course

          VBA-Training-Course
        • Others

          • Basic Excel Training
          • Advanced Excel Course
          • Tableau Certification Course
          • Excel for Finance Course

          • Excel for Marketers Course
          • Excel for HR Managers
          • Excel for Power Users
          • View All
  • Excel VBA All in One Bundle
  • Login

Proper Formula in Excel

Home » Excel » Text and String Functions in Excel » Proper Formula in Excel

By Sharmila Reddy Leave a Comment

Proper Formula in Excel

Proper formula in excel is used to change a given string in proper case, first what is a proper case, in-text strings proper case is a case where the first character of a given string is in upper case and the rest of the characters are in lowercase and this formula does the same for us, it is an inbuilt function which takes a single argument.

Proper Formula in Excel

As the name suggests, Proper Formula in Excel transforms the input string into the proper case.

Suppose there is a data which consists of 10,000 entries in different columns and the value in two columns Name and City are in small letters and want to capitalize the first character as we know the Name and City name come under noun and we have to start it with uppercase and this is where the Proper Function comes into play.

Proper Formula Example 1

Excel Proper Formula converts and capitalizes the first character of the string and remaining all the other characters same i.e in lowercase. While converting the string using Proper Function, the numbers and punctuations in a string will not get affected by it.

Proper Function is classified as Text function because it results in converting the first character of the string to uppercase and all remaining characters to lowercase.

we can find the function under Formula tab -> Text function -> Proper.

Proper Formula tab

From the above figure, we get to know about the location of the PROPER formula and from here we can directly load the function for use.

Popular Course in this category
Cyber Monday Sale
All in One Excel VBA Bundle (35 Courses with Projects) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
4.9 (1,353 ratings)
Course Price

View Course

Related Courses
VBA Macros CourseAdvanced Excel CourseTableau Certification Course

Formula of Proper Function

Proper Formula

It takes one argument, which is a string whose first character will be transformed to uppercase and the rest of the characters remains in lowercase.

There are two ways to load the proper formula in excel

  1. loading it manually (clicking PROPER function under the Text function)
  2. writing the function in the cell.

How to Use Proper Formula in Excel?

Below are examples of Proper Formula in excel.

Example #1 – Loading Proper Formula Manually

We have a dataset in Excel which contains the Name, City, Shipping Cost, Order Priority, Customer ID. Name and City are given in the small letters and we have to capitalize the first character of all the observation which comes under Name and City. Doing it one-by-one is a very difficult task and may consume nearly about 15-20 minutes. Here, for ease, we will use the PROPER function.

In this example, we will load the function manually.

Steps: –

  • Click on the cell where we have to put the required text.

Proper Formula Example 1-1

Here, we have selected the F2 cell.

  • Click on the Formulas tab then, under the Function Library group click on the TEXT When we click on the Text we’ll see lots of functions are there to use. But we need a PROPER formula which is shown below.

Proper Formula Example 1-2

  • After clicking, we will see that a dialog box appears with an input field in it named as Here, in this field we have to put the text argument which is required by the PROPER function.

Example 1-3

  •  It is a reference to a cell containing text. We will pass here the Name of the customer i.e. in A2.

Proper Formula Example 1-4

In the above picture, we see the difference between the input value and the results. As we can see that Formula results are showing, which is Lane Daniels. The first character of both the word is capitalized and the rest of the character remains the same i.e in lowercase.

  • After that, we will hit the OK button and the results will be displayed in the cell.

Proper Formula Example 1-5

As we see that the first character of each word in F2 is capitalized.

To convert all the name in the given format, we will just drag the cell from the bottom. After this, all the name has been converted to the same format.

Proper Formula Example 1-6

Example #2 – Writing the Proper excel Formula in Cell

Using the same above example, we will now change the characters of City using Proper formula.

 In this example, we will load the function manually.

Steps:

  • Select the cell where you want to put the required text. In this case, we have selected.

Example 2

  • In the second step, write the excel formula =PROPER(text).

Example 2-1

  • Then select the argument to be passed in PROPER Here, we have to pass the string because this function returns a string value. We will pass the reference to the cell containing text. We will pass here the City i.e. in B2 and close the parenthesis.

Proper Formula Example 2-2

  • Press Enter to get the result.

Example 2-3

As we see that the first character of each word in G2 is capitalized.

To convert all the name in the given format, we will just drag the cell till the bottom. After this, all the City name has been converted to the same format.

Proper Formula Example 2-4

Things to Remember

  1. Proper Formula in Excel converts and capitalizes the first character of the string and remaining all the other characters same i.e in lowercase.
  2. While converting the string using Excel Proper Formula, the numbers and punctuations in a string will not be get affected by it.

You can Download this Proper Formula Excel template here – Proper Formula Excel Template

Recommended Articles

This has been a guide to Proper Formula in Excel. Here we discuss examples of Proper Formula to convert the first character of the string to uppercase and all remaining characters to lowercase with downloadable excel template. You may learn more about excel from the following articles –

  • Create Formula in Excel
  • Frequency Formula in Excel
  • Rate Formula in Excel
  • Forecast Formula in Excel
  • TIME Formula in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>

Filed Under: Excel, Text and String Functions in Excel

Reader Interactions
Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer
COMPANY
About
Reviews
Blog
Contact
Privacy
Terms of Service
FREE COURSES
Free Finance Online Course
Free Accounting Online Course
Free Online Excel Course
Free VBA Course
Free Investment Banking Course
Free Financial Modeling Course
Free Ratio Analysis Course

CERTIFICATION COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Business Valuation Course
Equity Research Course
CFA Level 1 Course
CFA Level 2 Course
Venture Capital Course
Microsoft Excel Course
VBA Macros Course
Accounting Course
Advanced Excel Course
Fixed Income Course
RESOURCES
Investment Banking
Financial Modeling
Equity Research
Private Equity
Excel
Books
Certifications
Accounting
Asset Management
Risk Management

Copyright © 2019. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

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

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

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

Limited Period Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More