WorksheetFunction.Proper Method (Excel)
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
식 .Proper(Arg1)
식 A variable that represents a WorksheetFunction object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Arg1 |
필수 |
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