Robert Jan Ki
Robert Jan Ki

Reputation: 81

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

Upvotes: 4

Views: 298

Answers (1)

Enigmativity
Enigmativity

Reputation: 117124

Simple:

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

xlsx

Upvotes: 10

Related Questions