Forum Discussion
Copying Data from Word to Excel
Could you attach a small sample Word document demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
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.