LinkBack URL
About LinkBacks
Hello. I have data in a table in pdf and I need to get it into excel. When I copy it in the format is way off. How can I do this better? I've attached a copy of what the imported text looks like. Thanks.
Hello. I have data in a table in pdf and I need to get it into excel. When I copy it in the format is way off. How can I do this better? I've attached a copy of what the imported text looks like. Thanks.
Last edited by ammartino44; 01-03-2014 at 05:49 PM.
There are a few things you can do:
1) If in Acrobat, hold the ALT key while dragging the mouse. You can then select the columns individually and paste in Excel
2) If you want to copy all the numeric columns at once, hold the ALT and select ALL the numeric columns. Past this into Excel, then select DATA, Text to Columns, and use a SPACE as the delimiter.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks