PROPER

Name

Proper

Description

Capitalizes the first letter in each word of a text string.

Syntax

PROPER(text)

Remarks

The PROPER function capitalizes letters that follow any character other than a letter, for example, a space. The PROPER function converts all other letters to lowercase letters.

The text argument can be a string, a formula that returns a string, or a reference to a cell containing a string.

See also CHAR, LEFT, LOWER, MID, RIGHT, and UPPER.

Data Type

Accepts string data. Returns string data. For more information, see Data Type for Each Cell Type.

Example

PROPER(D2)
fpSpread1.Formula = "PROPER(""INTRO to SPREAD"")" equals "Intro To Spread"
fpSpread1.Formula = "PROPER(""Pam's date-nut bread"")" equals "Pam'S Date-Nut Bread"