Home » Excel-Built-In-Functions » Excel-Proper-Function Search this site: Custom Search

Related Functions : LOWER Function UPPER Function

Basic Description

The Excel PROPER function converts all characters in a supplied text string to proper case (ie. all letters that do not follow another letter are set to upper case and all other characters are lower case)

The format of the function is :

Where the Text argument can be supplied to the function directly, or as a reference to a cell containing text.

Example

The spreadsheet below shows examples of use of the Excel Proper Function. The spreadsheet on the left shows the format of the functions and the spreadsheet on the right shows the results.