Textjoin in a sequence within a range

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 to great for that A until XXX and i need to ignore blank cells within that range

>Solution :




Leave a Reply