Discussion Locked

How to export Acrobat Reader to Excel

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I would liek to be able to take a table from Adobe Acrobat Reader to Excel.Specifially, Dollar Spot Forward Against the Dollar Table published on www.FT.com.

I have saved the document as a text file adn then re-opend the converted file in Excel, but was unable to bring the various columns exactly as shown in Adobe. Some text shows in the data/number column. Adobe data is sepearted by blanks or spaces.

Does anyone know how to sucessfuly translate Adobe produced columns into excel.

3 replies

by dklippert

Excel looks at the first entry to determine data type.
One way to do this is to change the extention of your text file to something like .DAT
Excel will open the file using the Import Wizard and you can specify how you want the data handled.

This discussion is closed to new replies.