Concatenating with a twist...

[Atchu]

Hello

I am trying to concatenate cells to look like the following:

a a
b a;b
c a;b;c
d a;b;c;d
e a;b;c;d;e
f a;b;c;d;e;f
g a;b;c;d;e;f;g
h a;b;c;d;e;f;g;h

When i type in the forumula =A1&";"&A2 in cells b2 and drag down all i
gives me is:

a a
b a;b
c b;c
d c;d
e d;e
f e;f
g f;g
h g;h

Any help would be GREATLY appreciated!!!

Thanks :

 

[Alex Delamain]

Try the following in B2

=b1&";"&a2

then drag that down the lis

 

[Bob Phillips]

You also need to put =a1 in b1