Interject Documentation > jCombine()
Estimated reading time:
1 minute
Function Summary
The jCombine() function is helpful for developers who want to concatenate the values of cells while simultaneously skipping any empty cell. jCombine() can use both a cell range and a list of cell addresses. A list of cell address will require a delimiting character between each of the cell address in the list. The delimiter character can be custom, but it is a comma by default. When using jCombine() in a delimited list, it needs to have a second pair of parentheses around the first set.
Function Arguments
Parameter Name
|
Description
|
Default
|
Optional
|
SelectedRange
|
This designates a range of cells from a worksheet that will be concatenated. This can also be used with a delimited list of cells.
|
|
NO
|
Delimiter
|
This defines a character value that will designate a separation between cell addresses. The default delimiter is a comma.
|
|
NO
|
Function Composition
Formula
|
Example
|
Explanation
|
=jCombine(
(
SelectedRange
)
,Delimiter
)
|
=jCombine(
(
** "A1;B22;C4;I12" **
)
, **";"**
)
|
← A List or range of cell addresses to be concatenated.
← A custom character that separates each cell address in a delimited list.
|