PROPER

MS Excel Spreadsheet

See Also

Capitalizes the first letter in a text string and any other letters in the text string that follow any character other than a letter. Converts all other letters to lowercase letters.

Syntax

PROPER(text)

Text    is text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text you want to partially capitalize.

Example

The example may be easier to understand if you copy it to a blank spreadsheet.

ShowHow?

Data
this is a TITLE
2-cent's worth
76BudGet
Formula Description (Result)
=PROPER(A2) Proper case of first string (This Is A Title)
=PROPER(A3) Proper case of second string (2-Cent'S Worth)
=PROPER(A4) Proper case of third string (76Budget)