Hi Harald,

To add to the confusion; put q294b1 in cell A1 and 1 in B1, select both
cells A1:B1 and fill down. They suddenly behave identically.

Thats a nice line of inquiry. Didnt consider it.

I tried it with q294b1 in cell B1 and 1 in A1 (thinking it might be a
little different) and its same as q294b1 in cell A1 and 1 in B1.

So in both cases it mirrors as if the string (q294b1) is there in both
cells.

Regards,
Hari
India