Assuming columns A and B

In C1 enter =A1 & B1

Double-click on the fill handle(black lump at bottom right corner)of C1 to
increment the formula down the column as far as you have data in column B.

If you would like a space between the data........

=A1 & " " & B1


Gord Dibben Excel MVP

On Mon, 9 May 2005 16:26:03 -0700, sturville
wrote: