Evening all,
assuming I have Sheets2 to Sheets6 all with "hello" in cell A1 and I want to concat these all into a cell :
=INDIRECT("'Sheet"&ROW(2:6)&"'!A1") seems to hold the answer if I check via F2 then F9 :
{"hello";"hello";"hello";"hello";"hello";}
if I then apply the =MCONCAT function to this, it only brings back the first string entered normally :
=MCONCAT(INDIRECT("'Sheet"&ROW(2:6)&"'!A1"),";")
"hello"
or array-enetered :
{=MCONCAT(INDIRECT("'Sheet"&ROW(2:6)&"'!A1"),";")}
"hello"
rather than all 5 occurances....
what am I missing ?
thanks
Chris