I'm trying to textjoin a range with a delimiter:
Is there a way to textjoin this into a sequence every 3 cells within a range
I know I can do it with: A1&B1&C1&"-" etc. but my range is too great for that A until XXX and I need to ignore blank cells within that range
CodePudding user response:
Simple:
=TEXTJOIN({"","","-"},TRUE,A1:I1)