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)
Argument | Description |
---|---|
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?