PROPER function

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

Syntax

PROPER(text)

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

Examples

Formula

Description (Result)

=PROPER("this is a TITLE")

Proper case of string (This Is A Title)

=PROPER("2-cent's worth")

Proper case of string (2-Cent'S Worth)

=PROPER("76BudGet")

Proper case of string (76Budget)

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×