WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » PROPER Excel Function

PROPER Excel Function

PROPER Function in Excel

Proper Excel function is used to make the given input in proper case, proper case means in a word the first character is in uppercase while the rest of the characters is in lower case for instance in a name of a person we use this formula to make it in proper case, to use this function type =PROPER( and provide string as input.

PROPER function is categorized as String or Text function in excel. The PROPER function converts the first character to upper case and rests to lower case.

Basically, the PROPER function in excel is used to convert your input text to proper case. It can be used to capitalize each word in a given string. The PROPER function in excel will not affect numbers and punctuations in the given text or string. It will only convert the first character to upper case and all the other letters to lowercase.

PROPER Formula in Excel

PROPER Formula

The PROPER formula in excel has one compulsory parameter, i.e., text.

Compulsory Parameter:

  • text: The text or string whose first character in each word will be converted to uppercase and all remaining characters converted to lowercase.

How to Use the Proper Function in Excel?

PROPER function in excel is very simple and easy to use. Let us understand the working of PROPER in Excel by some examples. The PROPER function can be used as a worksheet function and as a VBA function.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course
You can download this PROPER Function Excel Template here – PROPER Function Excel Template

Example #1

In this example, we took a set of random text to apply the proper function to it, and the output is shown in the Output column. PROPER in Excel covert the supplied text to the proper format.

PROPER Example #1

Example #2 

In the second example, we use the input text having random spacing b/w words. So here, we have to use the Trim function with a PROPER function to get the well-formatted output. The proper function first covert each first word to the upper case, then the trim function removes all the unnecessary spaces from the supplied text, as shown in the below table.

PROPER Example #2

The PROPER in excel can be used as a VBA function.

Sub usefunction()

Dim rng As Range, cell As Range // declare two Range objects

Set rng = Selection // We initialize the Range object rng with the selected range.

// We want to check each cell in a randomly selected range (this range can be of any size). In Excel VBA, you can use the For Each Next loop for this. Add the following code lines:

For Each cell In rng
Next cell

cell.Value = Application.WorksheetFunction.Proper(cell.Value)

End sub

Things to remember 

  • Numbers and punctuation characters are not affected by the use of the PROPER function in the string.
  • The PROPER function converts the ‘s to ‘S, for example, tanuj’s to Tanuj’S.

Recommended Articles

This has been a guide to PROPER in Excel. Here we discuss the PROPER Formula in excel and how to use the PROPER Excel function along with excel example and downloadable excel templates. You may also look at these useful functions in excel –

  • PROPER Formula
  • LEFT Function in Excel
  • True Function
  • Choose Function in Excel
  • Weibull Distribution in Excel
2 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 >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. 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

WallStreetMojo

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

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

WallStreetMojo

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

Login

Forgot Password?

WallStreetMojo

Download PROPER Function Excel Template

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