Microsoft Office Tutorials and References
In Depth Information
Tip 73: Getting Data from a PDF File
Figure 73-2: Using copy and paste doesn’t work very well.
The data is copied, but it’s all in a single column. I could spend some time and rearrange the data, but
there’s a more efficient way to transfer the PDF file data to Excel.
When coping from a PDF file and pasting to a worksheet, the actual results will vary,
depending on the layout of the PDF file. In some cases, the pasted text is usable. But in
most cases, it’s not.