PROPER
PROPER
is a function that converts a string into its proper naming case. The first letter of each word is capitalized, and the other letters are in lowercase.
Syntax
string PROPER(string value)
Example
Can be used for various cases such as customer names, company names, product names and addresses:
PROPER("data synchronisation studio")
Will return "Data Synchronisation Studio".
You can pass column data into the function by entering the column name, such as:
PROPER(CompanyName)