Can you select the merged area first and then paste into the formula bar?

Rod wrote:

I have a single cell in one worksheet that I want to copy into another
worksheet where the cell is a merged cell of two cells. When I do this it
copies the one cell into both cells of the merged cells. I end up with two
of the same thing. I can not unmerge the cells that I am copying in to.

--

Dave Peterson