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?
