apply formula to entire column

  • Thread starter Thread starter vauneen
  • Start date Start date
V

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
 
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
 
Back
Top