Proper()

Home   Back   Next  

Working with Formulas > Functions Used in Formulas > Text Functions > Proper()

 

PROPER() converts any character in a string that follows a non-letter character to uppercase and every other character to lowercase.

 

 

Function Format

 

PROPER(string) 

 

 

Return Value

 

PROPER() returns a character string 

 

 

Examples

 

LOWER("apples") = "Apples" 

 

LOWER("apples and oranges") = "Apples And Oranges"