This is archived documentation for Docker v. Go to the latest docs or a different version:  null

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.