Howto concatenate Array values

I often run into a problem where values within an array need to be concatenated:

When I have an Array function e.g. =IF($A$2:$A$4=$A2;$B$2:$B$4;0)
I want all Array values concatenated:

Say result of IF function = {"A";"B";0} it will only show element index(1,1)="A"

in this example: A1=1, A2=1, A3=2, B1=A, B2=B, B3=C

Daddy,

Thanks for the reply. Is there a "work around". You must have encountered the same problem. Having a special add-in will make it work, but is not very handy in general as most will not have this installed.

The workaround would be to put the individual results in separate cells, then, if you must, you concatenate those results into one cell using Concat() or "&"

NBVC.

Thats exactly what I'm doing at the moment. Its'OK for an array of 4 elemenst, but for 10+ ... I just wanted to know if there was a way. I'll stick to the old method. THX all.