It seems to me that you want a macro that will concatenate all of the selected cells after the copy paste has been done. Won't that do it?