Pasting Table From Word Into Excel

itgolfer
itgolfer used Ask the Experts™
on
I have a 3 column table in Word that I'd like to copy into Excel. When I past it in Excel, it doesn't keep all of the rows together like it is in Word. Columns 1 and 3 are split between rows and the middle column is a merged cell so it's basically splitting columns 1 and 3 into 2 rows. Is there a way I can paste this in to keep the column and row formatting? This is in Office 2016.

Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Bill PrewIT / Software Engineering Consultant
Top Expert 2016

Commented:
It would be helpful if you could post the Word example, normally for simple tables they should copy correctly, so there is probably something interesting in the Word table.


»bp

Author

Commented:
Sorry, here you go.
Action-Plan.docx
your table is a little messy.

you have one action Change the required password length from 8 to 12 characters. in a single row

you have two actions Change the account lockout duration from 30 minutes to 0, requiring an administrator to unlock the account. and Change the number of failed attempts from 2 to 3. in the following row

you will get better results if you keep one action per row
Action-Plan-new.docx

Author

Commented:
Thanks. Maybe it's just easier to cleanup the table in Word instead of changing it after pasting it to Excel.
if you create the table in excel first, you get better results when you copy to word
action-plan-new.xlsx

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial