If the paste into Excel is just a list of values in one column we can turn to VBA for a bit of help. It may not be perfect, but it’s still closer than what you had before. Or maybe, which is more likely, you have a table which requires a bit of tweaking.
You may now have a perfect data table in Excel. However, Word is actually better at dealing with PDF tables. Here is our example PDF file: Copy table from PDF to Excel via WordĮxcel is a software program which is designed to work with tables, whilst Word is designed to work with text. One of these should work, providing reasonable results and saving you time. I would love to offer you the perfect solution to get the PDF data table into Excel, however I don’t believe there is one. If the paste displays as a picture, then as far as I know, you will need to resort to third-party software which contains OCR. If the paste is either a list of values or a continuous text string, then there are some possible workarounds. In my experience the pasted data will show as one of the following: The pasted information will be displayed in Excel differently based on how the PDF was created. Pasted Strings: Use VBA to split the string.
0 kommentar(er)
