Related Topics:
	Spreadsheet Mathematical Functions Data Entry Tips for Functions

PROPER

Description: Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. It 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:

• PROPER("this is a TITLE") = "This Is A Title"

• PROPER("2-cent's worth") = "2-Cent'S Worth"

• PROPER("76BudGet") = "76Budget"