Concatenate Array of Cells

[austinandrei]

Hi,
Is there a way to concatenate an array of cells? Like the one which combine CONCATENATE and TRANSPOSE formula though what I need is horizontal.
Like I will need to concatenate values from Column A to Z so ideally, the formula I need is like below:
=CONCATENATE(A1:Z1,"[]")
Unfortunately, above is not functioning.
I am using Excel 2010 so TEXTJOIN formula is not existing.
Array Formula is welcome, not the VBA.
As I want this to be useful for any case like if the cells to be concatenated is D5:S5 and others.
Thanks!

 

[Aladin Akyurek]

ACONCAT is a well-designed udf which proved itself thru since Grove wrote it up...

 

[austinandrei]

Hi Aladin, sorry, I was so focused on having that with CSE when it is being part of a whole coding series, but I tried on just using "=aconcat(B2:BA2,"|")" and its working! many thanks!

 

[Aladin Akyurek]

Hi Aladin, sorry, I was so focused on having that with CSE when it is being part of a whole coding series, but I tried on just using "=aconcat(B2:BA2,"|")" and its working! many thanks!

You are very welcome. Also, thanks for the update.