Export (0) Print
Expand All
Expand Minimize

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.

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

Show:
© 2014 Microsoft