K
Kenneth Lam
Other than using:
=concatenate(A1,A2,A3,A4,A5)
or
=A1&A1&A3&A4&A5
or
VBA code
is there any way to do concatenate like
=XXXX(A1:A5) ?
I have tried using concatenate in array but doesn't work.
Thanks
=concatenate(A1,A2,A3,A4,A5)
or
=A1&A1&A3&A4&A5
or
VBA code
is there any way to do concatenate like
=XXXX(A1:A5) ?
I have tried using concatenate in array but doesn't work.
Thanks