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 |
---|---|
PROPER(“alan storm”) | Alan Storm |
PROPER(“SUSAN GRAHAM, C@ss n1te, dEaN wHiTe”) | Susan Graham, C@Ss N1Te, Dean White |
PROPER(“this is a TITLE”) | This Is A Title |
PROPER(“2-way street”) | 2-Way Street |
PROPER(“76BudGet”) | 76Budget |
See also
Excel: PROPER