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
Last updated
Was this helpful?