PROPER
Functions to Convert Between Upper & Lower Case

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 :

PROPER( text )

Where the text argument is the original text string, that you want to convert to proper case.

Note that, as well as the first letter of every word, letters following numbers or other punctuation are converted to upper case by the Excel Proper function. This may be in places that you might not expect - for example, the function converts the "s" in the text string "Bob's Boat" to upper case - i.e. "Bob'S Boat".

Proper Function Examples

The spreadsheet below shows four examples of the Proper function.

The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

Excelq.com doing business as a Service of Venttraffic Media Inc. Excel and other words on this site may be trademarks or registered trademarks of Microsoft Corporation. Microsoft Corporation is not connected in any way with this website, and makes no endorsement of the site or its related contents. All rights reserved. Website powered by Venttraffic Media Inc.