Hi,

not sure why you need a macro.

To contatinate strings or cells use "&".

So in cell c1 you can put the following formula;

=A1&B1

If you then copy (Ctrl +C) the contents of C1,
put your cursor in cell B1 and
Ctrl + Down Arrow, this will take you to the last cell in the range,
move the cursor to to the right (back in to column C)
Ctrl + Shilft + Up Arrow
Press Enter

This should copy this formula for all the cells.

Note you can contatinate stings as well: e.g.

=A1 & " This is a test " & B1

HTH

Art