Excel Proper Function

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

Description

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 PROPER function is available in Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000, Excel 2011 for Mac.

Syntax

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.

Example

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
    if you want to change all text string in uppercase into lowercase, you can create a formula based on the Lower function. And if you want to convert all letters in one cell into uppercase, you can use the Upper function as a formula in excel.…
  • 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.…

Leave a Reply