PROPER

The PROPER function returns a string value where the first letter of each word is uppercase and all remaining characters are lowercase, regardless of the case of the characters in the specified string value.

PROPER(source-string)

source-string: Any value. However, only string values are affected by the function.

Notes

  • Any character following a non-alphabetic character, except apostrophe (’), is treated as the first letter in a word. So, for example, any letter following a hyphen is capitalized.

Examples

=PROPER("lorem ipsum") returns "Lorem Ipsum".

=PROPER("lorem’s ip-sum") returns "Lorem’s Ip-Sum".

=PROPER("1a23 b456") returns "1A23 B456".

=PROPER(60) returns "60".

See alsoLOWERUPPER
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Uporabno?
Omejitev znakov: 250
Zgornja omejitev znakov je 250.
Hvala za povratne informacije.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.