Assuming Columns 1 and 2 are Columns A and B, put this formula in a third
column and copy down as needed...

=A1&" "&B1

--
Rick (MVP - Excel)


"The Cable Guy" wrote in message
...
Trying to concatenate two columns

eg
column 1 column 2
1234 2nd st
2345 3rd st
3456 4th st
4567 5th st