How can I copy Word data into a merged cell in Excel?

S

Suzan Wild

I am trying to copy some text from a Word document into an Excel spreadsheet.
I get an error message about "data not same shape" then I get an error
message "cannot copy data into merged cell." I'm on Office 2002.
 
P

Peo Sjoblom

Unmerge the cell and paste it into the upper leftmost of the cells that were
merged, then merge again although I would strongly advice NOT using merged
cells, sooner or later (sooner) they are bound to cause problems, it is
pretty easy to get similar layout with center across selection etc

Regards,

Peo Sjoblom
 
Top