Hi everyone!
Here is a task about array, I can't resolve.
I have the array like {text1,text2,text3} and I want to joint elements of the array in string like "text1text2text3"
I try to use array formulas, but it doesn' work
Why Mcrosoft haven't realize sum-like formula for text 
And one more question about arrays: Is any way to get element of array from cell with formula like above:
"={text1,text2,text3}"? If there isn't, may be some MVP-s could offer to realize that function to MS?
Many thanks for replies!
Here is a task about array, I can't resolve.
I have the array like {text1,text2,text3} and I want to joint elements of the array in string like "text1text2text3"
I try to use array formulas, but it doesn' work


And one more question about arrays: Is any way to get element of array from cell with formula like above:
"={text1,text2,text3}"? If there isn't, may be some MVP-s could offer to realize that function to MS?

Many thanks for replies!