PROPER

The PROPER function converts the first character of each word in a text string to uppercase and converts the remaining characters to lowercase. This function is commonly used to format text in proper case.

Syntax

PROPER(value)

Arguments

• value: The text string to convert to proper case.

Return value

Returns the text string in proper case.

Example

PROPER("annual SALES report")

Returns Annual Sales Report.

Excel equivalent

PROPER