apply formula to entire column

[vauneen]

hi,
i need to concatenate the content of one column with the
content in another and display that in a 3rd column

CONCATENATE(A1,"",B1), this works for just one cell but
how do i apply this to every row:
CONCATENATE(A2,"",B2)
CONCATENATE(A3,"",B3)
CONCATENATE(A4,"",B4)
CONCATENATE(A5,"",B5)

any help appreciated,
Vauneen

 

[Andy Brown]

Vauneen

When you select C1 there should be a small black square at its bottom
right-hand corner - the "fill handle".

Click on it and drag down to replicate the formula in C2, C3, etc.

Anyway, you can get away with =A1&B1.

Rgds,
Andy

 

[Guest]

thanks a million for the help
(and the speed)
much appreciated

Vauneen