Skip to main content

PROPER

The PROPER function returns a string where the first letter of each word is uppercase and the rest are lowercase.

This function can be useful for formatting names, titles, and other texts.

Syntax​

PROPER(string)

ArgumentDescriptionPermitted values
stringString in which the first letter of each word is converted to uppercase and all others to lowercaseText string or reference to a cell containing text

Examples of use​

String conversion

=PROPER("hello, world")

This formula will return "Hello, World".

Converting text from a cell

=PROPER(A1)

If cell A1 contains “editor functions,” the formula will return “Editor Functions”.

Converting text with different case

=PROPER("THis function CONVERTS tEXt")

This formula will return "This Function Converts Text".

Notes​

  • The function does not recognize abbreviations: for example, “NASA” will be converted to “Nasa”.
  • The function may not correctly process names with prefixes. For example, “van Gogh” will be converted to “Van Gogh”.