Concatinate values in a Range or Array using Native Formula

[LalitPandey87]

Hi All

Hope you are good.

After a long time i am here again looking for your help.

Is it Possible to concatenate a range or array by using Native formula.

i.e. :- =CONCATENATE({"A";"B";"C";"D"}) will give A but i need ABCD.

I can do it with the help of VBA but looking for a formula which will give the desired output.

Thanks in Advance.