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.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function Proper ( _
Arg1 As String _
) As String
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As String
Dim returnValue As String
returnValue = instance.Proper(Arg1)
string Proper(
string Arg1
)
Parameters
Arg1
Type: System.StringText - 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
Type: System.String