Proper

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

📘
This function isn't compatible with all data platform connections. To check if your connection supports it, see Supported data platforms and feature compatibility.

Syntax

Proper(string)

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.

Examples

Proper("aPPles AnD oranGEs")

Returns Apples And Oranges.

Proper([Product Family])

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