Thats my point...

I highlight column B in sheet 1 and then go to column B in sheet 2 and
paste. because column B is merged with CDEF&G the question is pasted into
thise cilumns too, even though the cell was merged. Pasting demerges and
places the question in 6 cells horizontally!

"merjet" wrote:

If Sheet2_Col_C is "just text", then how does copying from
Sheet1_Col_B to Sheet2_Col_B affect Sheet2_Col_C? At least that's the
way I read your #1. I can understand Col_C being affected if it has a
formula, but not if it "just text."

Hth,
Merjet