austinandrei
Board Regular
- Joined
- Jun 7, 2014
- Messages
- 117
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!
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!