Can't do it with copy paste, but you can concatanate them:
If you cells are A1, B1, C1 and the destination is D1 you would type i
D1:
=A1 & B1 & C1
If you need to add spaces between, use
=A1 & " " & B1 & " " & C1
--
Message posted from
http://www.ExcelForum.com