PROPER
Formula Explanation
Converts the initial letter of a text string and any subsequent letters after any non-alphabet characters to uppercase, while converting the remaining letters to lowercase.
Formula Syntax
PROPER(text)
The PROPER function syntax has the following argument:
- Text (required): The text enclosed in quotation marks, a formula that returns a text value, or a reference to a cell containing the text to be partially converted to proper case.
Usage Example
Convert the values in column DW2 to proper case and write the results in column DW3.
DW3 = proper(dw2)