How do I transfer data in a pdf file into an excel workbook?
How do I transfer data in a pdf file into an excel workbook?
|
Open the .pdf file in Acrobat Reader.
Edit SelectAll Ctrl-C (to copy) Switch to Excel, cell A1 Ctrl-V (to paste) You now have a 1 column TEXT file in Excel........it can be "broken out" using the Data TextToColumns feature...... Vaya con Dios, Chuck, CABGx3 "CBooze1969" wrote: How do I transfer data in a pdf file into an excel workbook? |
A post from Jason Morin........
You can convert the pdf to an html file, and then open it up in Excel. Of course you'll lose formatting but you can reconstruct it with formulas and/or macros. You need to download pdf995 to start the process: http://www.pdf995.com/ HTH Jason Atlanta, GA Gord Dibben Excel MVP On Tue, 19 Apr 2005 07:12:02 -0700, "CBooze1969" wrote: How do I transfer data in a pdf file into an excel workbook? |
All times are GMT +1. The time now is 07:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com