I have the following string in column H and I.H2=http://I2=aaaH3=http://I3=bbbI want to have a auto-generated J column, which results like:J2=http://aaaJ3=http://bbbSo I put the following formula in J1:= ARRAYFORMULA (IF(ROW(J:J)=1;formulaTest;CONCATENATE(H:H1, I:I1 ) ))But the result I got is:J2=http://http://aaabbbJ3=http://http://aaabbbWhat is going wrong with my formula?
CONCATENATE a string with an ArrayFormula
google spreadsheets
This is what you are looking for:=ARRAYFORMULA((IF(ROW(J:J)=1,formulaTest,H1:H & I1:I)))