Concatenates data from a range using a specified separator.

This is particularly useful for the Setup parameters editor‍ . 

Syntax

=MM_CONCATENATE(Range, "Separator")

• Range
  The range that contains data you wish to concatenate.

• Separator (optional)
  A string that separates each data from Range. The default value is set to "|" (pipe).

Example

• Formula: =MM_CONCATENATE(A2:A6) in cell E3
  Returns "Very satisfied | Satisfied | Neutral | Unsatisfied | Very unsatisfied". This is the correct way to define possible values in the parameter editor. The above example will define a radio button with five possible values.