The Proper function converts text to proper case, which capitalizes the first letter of each word and renders all remaining letters in lowercase.



Function arguments:

  • string (required) - a text string or column to reference when converting text to proper case


If the string argument references a column, the column must contain text values. Other data value types result in an invalid formula.


Proper("aPPles AnD oranGEs")

Returns Apples And Oranges.

Proper(\[Product Family\])

Returns the proper form of the text value in the Product Family column.

Related resources