The jCombineSmart function concatenates a range or multiple ranges of cells into a single string using a designated delimiter. Blank cells and duplicate cells are skipped and the resulting concatenation is sorted. This function can also be set to interpret the input as numbers so that sorting can be numerically ascending. In addition, it applies continuous ranges where possible. For example, "2,6,6,1,3" becomes "1..3,6".
This function can be used as a standalone function and does not need to be embedded in another function.
Function Arguments
Type
Range/(Range, Range, …)
Constraints
Max 7 ranges
If Blank
Function Error
Type
String
Constraints
Max 255 char
If Blank
","
Type
String
Constraints
Max 255 char
If Blank
".."
Type
Boolean
Constraints
If Blank
False
Excel Formula Bar Example
=jCombineSmart(F2:L2, "|", "...", True)
Function Composition
Argument Name
Example Mapping
Explanation
Function Name
=jCombine()
The name of this function.
Selected Range
F2:L2
The range F2:L2 will be the values concatenated.
Delimiter
"|"
The pipe "|" will be used as the delimiter for the concatenation.
Range Code
"…"
Three dots "…" will be used as the range operator for continuous ranges.