How To Use Excel PROPER Function

Quick Intro

Use Excel PROPER Function to change a text into a proper case in which the first letter of a word will in upper case and rest of the letters are in lower case.

Syntax

PROPER(text)

  • text Text which you want converts to proper case.

Additional Information on Excel PROPER Function

  • It can only convert text into the proper case.
  • Any value which is not text will not change.
  • It capitalizes the first letter the word that follows a non-text character. =Proper(“excel-champs”) = Excel-Champs.

Examples

In the below example, a proper case has the first letter in the capital case in a word and rest of the letters are in the lower case comparing to other two cases lower case and upper case.

You can use this function where you want to streamline your text into a proper case.

 Use Excel Proper Function To Convert Text Into Proper Case

In the below example, we have used the proper function to streamline first name and last name into the proper case. It will convert the first letter into a capital letter of each word which has space before it.

Even if there is a simple alphabet in a cell it will convert that alphabet into a capital letter.

Examples For Excel PROPER Function

Sample File

download sample file to learn more about this tips

What’s Next?

To learn more about Excel PROPER Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have UPPER | LOWER function which are highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.