Forum Discussion
Copying Data from Word to Excel
Hi, I am trying to copy data from Word to Excel. The data in Word seems to be in text format. When I paste it in excel, it gets perfectly copied except the columns. What happens to the columns i...
Hi,
Thanks for your response. Here is a link of the word file - https://1drv.ms/w/c/8ed9864fa16ac1b5/Efx0APa60bVIvEPjGXeJwssBKRSpZibS1ObjJznwq2scTA?e=yczEnW
Thank you. That Word document is really horrible! The "columns" have been created by placing different tab stops depending on where the data should be positioned.
For example, the ruler for the Anatomical Pathology line looks like this:
But for the CAC (Family Practice Anesthesia), it looks like this:
As you can see, there are no intermediate tab stops, so Excel will place the data in adjacent columns.
Can you get whoever created the Word document to produce a better formatted one?
Otherwise, I fear you'll have to correct the data by hand.