Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Textjoin in a sequence within a range

I'm trying to textjoin a range with a delimiter:

example

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

like image 900
Robert Jan Ki Avatar asked Oct 15 '25 04:10

Robert Jan Ki


1 Answers

Simple:

=TEXTJOIN({"","","-"},TRUE,A1:I1)

xlsx

like image 124
Enigmativity Avatar answered Oct 17 '25 17:10

Enigmativity



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!