Sunday, 8 September 2013

Concatenate cells in excel

Concatenate cells in excel

I have two columns of data as follows:
A1: A; A2: B; A3: C and B1: 1; B2:2; B3:3
Is there a simple loop in VBA to have on column C the concatenated values as:
C1: A1; C2: A2; C3: A3; C4: B1; C5: B2; C6: B3; etc?

No comments:

Post a Comment