In article <ee9a3b7.5@[EMAIL PROTECTED]
>, jo@[EMAIL PROTECTED]
wrote:
> 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.
|
