Excel Proper Function

This post will guide you how to use Excel PROPER function with syntax and examples in Microsoft excel.


The Excel PROPER function capitalizes the first character in each word of a text string and set other characters to lowercase .

The PROPER function is a build-in function in Microsoft Excel and it is categorized as a Text Function.



The syntax of the PROPER function is as below:

= PROPER  (text)

Where the PROPER function arguments are:
Text -This is a required argument. The text string that need to capitalize the first character in each word and the rest characters in each work will convert to lowercase.


The below examples will show you how to use Excel PROPER Text function to set the first character to uppercase in each word and set the rest characters in each word to lowercase.

#1 To proper case of the text string in B1 cell, just using formula: =PROPER (B1)

excel proper function example 1

More Related PROPER Function Examples

  • Change Uppercase and Lowercase Text
  • Change Uppercase to Title Case or Sentence Case in Excel
    If you want to change uppercase letters to title case in Excel. you need to use a formula based on the PROPER function to achieve it.…