WorksheetFunction.Proper Method
Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.
Syntax
expression.Proper(Arg1)
expression A variable that represents a WorksheetFunction object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Arg1 | Required | String | Text - text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text you want to partially capitalize. |
Return Value
String