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.
