The PROPER function is used to convert the first character of each word in a cell to uppercase and the remaining characters to lowercase.
The syntax for the PROPER function is:
=PROPER(text)
Argument | Purpose |
---|---|
Text | The text you want to convert to proper case, usually entered as a cell reference |
The example below shows the PROPER function being used to convert the text in cells A2 and A3 to proper case.
