Capitalizes the first letter of each word. All other letters are set to lowercase.

 

Usage

Proper(string)

string [required]  A string of text or text column.

Examples

Example #1

Proper("aPPles AnD oranGEs")

Returns Apples And Oranges.

Example #2

Proper([product family])

Returns the Proper form for each row in  [product family] column.

See Also

Text Function Overview