Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Among the standard functions of Calc specified by 'OpenFormula' there are none capable of concatenating ranges in an accumulating way. Starting with V 5.2 two new functions for the task were implemented for compatibiltiy with an obscure version of Excel. After some bug fixing they are actually usable now (V 5.4.y.z e.g.). However there is not yet a satisfying help text. See bug tdf#99517.

If you want to simply concatenate your example should look like =CONCAT(A1:C1). If you want to insert a delimiter between any two cell contents you can use =TEXTJOIN(myDelimiter; myMode: A1:C1). 'myDelimiter' is the string to insert, myMode can be 0 or 1 distinguishing whether (0) the delimiter will also be inserted if an adjacent text is empty or (1) empty cells are ignored.

Among the standard functions of Calc specified by 'OpenFormula' there are none capable of concatenating ranges in an accumulating way. Starting with V 5.2 two new functions for the task were implemented for compatibiltiy with an obscure version of Excel. After some bug fixing they are actually usable now (V 5.4.y.z e.g.). However there is not yet a satisfying help text. See bug tdf#99517.

If you want to simply concatenate concatenate, your example should look like =CONCAT(A1:C1). If you want to insert a delimiter between any two cell contents you can use =TEXTJOIN(myDelimiter; myMode: myMode; A1:C1). 'myDelimiter' is the string to insert, myMode can be 0 or 1 distinguishing whether (0) the delimiter will also be inserted if an adjacent text is empty or (1) empty cells are ignored.

Among the standard functions of Calc specified by 'OpenFormula' there are none capable of concatenating ranges in an accumulating way. Starting with V 5.2 two new functions for the task were implemented for compatibiltiy with an obscure version of Excel. After some bug fixing they are actually usable now (V 5.4.y.z e.g.). However there is not yet a satisfying help text. See bug tdf#99517.

If you want to simply concatenate, your example should look like =CONCAT(A1:C1). If you want to insert a delimiter between any two cell contents you can use =TEXTJOIN(myDelimiter; myMode; A1:C1). 'myDelimiter' is the string to insert, myMode can be 0 or 1 distinguishing whether (0) the delimiter will also be inserted if an adjacent text is empty or (1) empty cells are ignored.ignored.

(Editing)
See also this attached demo.
(Original filename: ask132310AccumulatingConcatenation_1.ods)

Among the standard functions of Calc specified by 'OpenFormula' there are none capable of concatenating ranges in an accumulating way. Starting with V 5.2 two new functions for the task were implemented for compatibiltiy with an obscure version of Excel. After some bug fixing they are actually usable now (V 5.4.y.z e.g.). However there is not yet a satisfying help text. See bug tdf#99517.

If you want to simply concatenate, your example should look like =CONCAT(A1:C1). If you want to insert a delimiter between any two cell contents you can use =TEXTJOIN(myDelimiter; myMode; A1:C1). 'myDelimiter' is the string to insert, myMode can be 0 or 1 distinguishing whether (0) the delimiter will also be inserted if an adjacent text is empty or (1) empty cells are ignored.

(Editing)
See also this attached demo.
(Original filename: ask132310AccumulatingConcatenation_1.ods)