concat Function

Returns a string by concatenating the values of the specified columns and input strings. For example, to display the close date as MM-DD-YYYY, concatenate the Close_Date_Month column, Close_Date_Day column, and Close_Date_Year column, and add a dash between each of them.

Required Editions

Available in Salesforce Classic and Lightning Experience.

Available with CRM Analytics, which is available for an extra cost in Enterprise, Performance, and Unlimited Editions. Also available in Developer Edition.

Syntax

concat(string1,string2,...)

Arguments

Argument	Description
string1	First dimension field or text string to include in the concatenated value.
string2	Second dimension field or text string to include.

Note This function also appears in the Suggestion bar when you select multiple dimension columns in the recipe editor.

Example To create the full name, concatenate the first and last name with a space in between them as shown in the following formula.

concat([OwnerId.FirstName]," ",[OwnerId.LastName])