In Word I select and copy this table:



Then in Excel (new sheet) I paste it, hoping for:





but I get:



Oh dear. B1 is split and A1 has a merged A2.

How can I get the desired result without manual fixup?

Cross post Just a moment...

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

chrisjj: Kindly stop creating multiple threads on essentially the same topic. You have been advised not to do so before. You also been advised about the expected cross-posting etiquette, which you're also ignoring. Keep it up and your account here will be terminated.

Thread closed. Any discussion can continue in: https://www.msofficeforums.com/excel...reserving.html

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]