Description
Capitalizes the first letter in a text string, as well as any letters following non-alphabetic characters, while converting all other letters to lowercase.
Syntax
PROPER(Text to Convert)
Arguments
Argument | Type | Dimensions | Description |
|---|---|---|---|
Text to Convert (required) | Text | Any Dimensions | Text values to convert. |
Return type
Type | Dimensions |
|---|---|
Text | Dimensions of Text to Convert |
Examples
Formula | Result |
|---|---|
|
|
|
|
|
|
|
|
|
|
See also
Excel: PROPER