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)
Argument |
Description |
Permitted values |
|---|---|---|
string |
String in which the first letter of each word is converted to uppercase and all others to lowercase |
Text 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”.