|
CONCAT.RANGE – concatenate range data
Concatenate cell values to a string using optional string delimiters. You can add strings to the start and end, format numbers and skip or replace blank/empty cells.
CONCAT.RANGE is a multithreaded, non-volatile, non-array function.
CONCAT.RANGE Syntax
CONCAT.RANGE (ConcatThis, Divider, NumberFormat, BlankSkipReplace, LineStart, LineEnd)
ConcatThis
A range or array of values to be concatenated.
Divider (optional, default “”)
The character(s) to use as a divider between the concatenated items
NumberFormat (optional)
The number format to apply to numeric values.
BlankSkipReplace (optional, default False)
If True then empty and zero-length values will be ignored.
If False then empty and zero-length values will be included.
If a Text-string it will be used to replace empty and zero-length values.
LineStart (optional, default “”)
Text-string to insert before the first value.
LineEnd (optional, default “”)
Text-string to insert after the last value.
|
