Excel PROPER Function

HomeExcel FunctionsExcel PROPER Function (Example + Sample File)

What is EXCEL PROPER FUNCTION

The Excel PROPER Function is listed under Microsoft Excel's Text Functions category. It returns the text string into a proper case. In simple words, with a PROPER function where the first letter of the word is in capital and rest in small (proper case).

How to use it

To learn how to use the PROPER function in Excel, you need to understand its syntax and arguments: 

Syntax

PROPER(text)

Arguments

  • text: The text string which you want converts to proper case.

Notes

  • It can only convert text into the proper case, any value which is not text will not change.
  • It capitalizes on the first letter the word that follows a non-text character.

Example

To master the PROPER function we need to try it out in an example and below is one which you can try out:

In the below example, we have a proper case that has the first letter in the capital case in a word and the rest of the letters are in the lower case compared to the other two cases lowercase and uppercase.

In the below example, we have used the PROPER function to streamline first name and last name into the proper case.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.