Concatenate Single Cell Array Constants

I would like to concatenate single cell array constants without taking help of other cells. A1={"A","B"} & B1={"1","2"}. As I could not access the cell array characters directly from the cell, I've named them as ARRAY1 & ARRAY2 & then used INDEX to get the desired result in C1 i.e., A1 , B2
Now, the array constant {"A","B"} is having 1 row & 2 columns but if I want the INDEX formula (or any other formula) to repeat itself & add them for 'n' number of columns in Array i.e., {"A","B","C",........,"n"}, what formula should I use?

Is there any way out without naming the array constants?

VB script not allowed.

Originally Posted by excelformulae

VB script not allowed.

In that case, you have posted in the wrong sub-forum (just look at the name of this sub-forum). Your question should have been posted in the "Excel Formulas & Functions" sub-forum.