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.…
Related Posts

How To Force Text String to Upper,Lower, or Proper Case in Excel

This post will guide you how to force test strings to uppercase or lowercase or Proper cases through an Excel formula or data validation in your Excel 2013/2016. How to convert text to upper, lower, or proper case in Excel. ...

How to Check If a Cell is Uppercase, Lowercases or Capitalize in Excel

This post will guide you how to check if a cell is uppercase in Excel 2013/2016. How do I identify all letters in cells are lowercases or capitalize in Excel. How to change letters to uppercase, lowercases or capitalize first ...

How to Capitalize First Letter of Each Word in Excel

This post will guide you how to capitalize the first letter of each word in a cell in Excel. How do I capitalize the first letter only with a formula or VBA Macro in Excel. Capitalize the First Letter of ...

Change Uppercase to Title Case or Sentence Case in Excel

This post will guide you how to change uppercase letters to sentence case with a formula in Excel. How do I change uppercase to title case in Excel. How to change Uppercase to title case or sentence case with VBA ...

Change Uppercase and Lowercase Text

This post will guide you how to change the case of text to uppercase or lowercase in Excel. How do I change all uppercase text to lower case with an Excel formula. For example, if you want to change all ...

Comments

So empty here ... leave a comment!

Leave a Reply

Sidebar