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 is that, if there is an empty cell, then it is replaced by the data that is to the right of it. Thus the values in the columns shifts left if there are empty cells.
Can anyone please help me sort it out? The volume of data is large, thus manually correcting these is not feasible.
I have provided a screenshot of the data that is in word. Here is also a link of the word file - Report.docx
Thank you.
5 Replies
An option could be to save the file as .txt and import it into Excel with Power Query
For another less-than-optimal possibility, see the attached workbook.
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?
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.
