Paste into one cell
 

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