Pasting Table From Word Into Excel

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.
itgolferAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bill PrewCommented:
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
0
itgolferAuthor Commented:
Sorry, here you go.
Action-Plan.docx
0
Paul SauvéRetiredCommented:
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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
itgolferAuthor Commented:
Thanks. Maybe it's just easier to cleanup the table in Word instead of changing it after pasting it to Excel.
0
Paul SauvéRetiredCommented:
if you create the table in excel first, you get better results when you copy to word
action-plan-new.xlsx
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.