Sunday, August 17, 2014

microsoft word - Import table into Excel 2013 and format

I was sent 5 pages of a Microsoft Word table for my sister's wedding guest's. Each individual cell contains contains all the info for a card to send in the mail: Mr. and Mrs. John Doe, 1111 Address Street, City, State, Zip.
I was asked to transfer this information to a Microsoft Excel spreadsheet with the columns as follows: Title (Mr. and Mrs. etc), Name, Address, City, Zip. Each row is supposed to be a different entry.
As the info is all located in one cell, I cannot figure out the best way to import it without manually doing a copy/paste. Does anyone know of a time efficient method of importing this data from the Microsoft Word tables to a Microsoft Excel 2013 spreadsheet and having it put the info in the correct places?
Thank you for any and all tips, suggestions and/or solutions!

No comments:

Post a Comment

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...