Converting EPrint files to Excel:� Alternative method Using Adobe Acrobat.� You must have Adobe Acrobat in order to do this; it is not possible to convert files with Adobe Reader.� These instructions are for Adobe Acrobat 6.0
With the PDF Eprint file displayed on screen, select File, Print.� In the printer dialog box, select Adobe PDF, then click OK
NOTE:� In the Print Range section of the dialog
box, select any appropriate options.�
Click the Properties
button to set paper size, landscape, etc. if
needed.
When prompted save and name the file, making sure that �PDF Files� is selected under Save As Type
Once processing is complete, the new document will display in Adobe Acrobat.� Now you can use the Select Table tool in Acrobat to select portions of the table for inclusion in an Excel worksheet or an email.� In Acrobat, make sure that Select Table is selected from the menu.
Once Select Table is selected, click and drag over the portion of the table that you want to select.� When you release the mouse button the selection will be surrounded by a blue border.
Right click on the selection and select
- Copy selected table� to copy the table for placement in an email
- Open Table in Spreadsheet to open the table in an Excel workbook
Excel�s Text to
Column Feature
Excel has a �text to column� feature that can be used to separate data into more than one column.� This might be useful if your Eprint file merges two or more columns of data into one when it is converted into Excel.� In the example below, the SSN column and the name column were combined when the Eprint file was coverted.
Insert a column after the column that contains data info you want to separate (in this case, the column would be inserted after the first column).
Now select the data that needs to be separated and from the Excel menu, select Data, Text to Columns.
In the Convert Text to Columns Wizard dialog box, Select Fixed Width (or delimited, if that is the case)
�-
Select Next, select Finish.