XL.Concatenate function

XL.Concatenate function – Text function type – сoncatenates all values in a range. Optionally with a delimiter and format.

Syntax

=XL.Concatenate(range, separator, format)

ArgumentDescription
range
[required]
A range of cells which values you would like to concatenate.
separator
[optional]
A text representing a values separator.
format
[optional]
A format which should be applied to each particular value before concatenation.

Any questions or suggestions?
How can we help?