Merge text withing a given area into one cell

[Imbizile]

Hello all

Im wondering if there is an easy vba way to merge text withing a given area into one cell, with a specifiec delimiter. Pretty much the opposite of the Text to Columns function. Like the below example:
MergeCells.png

I need it to be generic, as there are only 3 columns in this example, but in my actual data I have more than 100 columns and thousands of rows in the given area.

Really hoping someone have a solution for this and appreciate any help

Best regards
Imbizile

[Fluff13]

How about
=TEXTJOIN(H$2,1,A2:E2)

[Imbizile]

That was just what I was looking for - thanks so much

[Fluff13]

You're welcome & thanks for the feedback.