Regardless, my point was I have never encountered this problem before. Does
anyone know how to fix it? I am trying to combine tables created by various
people, so I can't control whether or not they have included merged cells in
the past. The fix described above erases all the data except that in the top
left cell.
I'm confused, are you the previous poster who wrote "I merged cells on
purpose"?
The thread you responded to doesn't have any fixes (at least, not as far
back as the headers have references), so I'm not sure which fix you're
referring to.
If the cells are already merged, the only data that exists is in the top
left cell of the merge, so you won't lose data by unmerging. Only if you
merge previously unmerged cells will you potentially lose data.
One potential solution, if your data is all constants (rather than
formulae, is to save the worksheet as a .csv file. When you read it back
into XL, the merges will be gone (along with all other formatting), and
the data will be in the left-most cell of the previously merged cells.