Google Sheets: Remove comma between specific cells in an TEXTJOIN-CodePudding

I'm using an ARRAYFORMULA / TEXTJOIN formula in Google Sheets to pull selected data together to make a single line of code arranged in a specific way for my project.

The resulting array needs to both INCLUDE commas in the first half, as well as EXCLUDE commas towards the end of the same formula.

Option 02

Use this formula to replace the last set of commas

=REGEXREPLACE(B12, 
              REGEXEXTRACT(B12&"", " --ar. ?(,. )"), 
              REGEXREPLACE(REGEXEXTRACT(B12&"", " --ar. ?(,. )"), ",", ""))

CodePudding user response：

Try this simpler formula (based on your formula)

=INDEX(concatenate("signal code: ",
  TEXTJOIN(", ",1,C5:C8,C3,I5:I8) & " " 
& TEXTJOIN(" ", 1,I9, O5, O6, O7, O8)))