Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 38
Default Why won't the copy/paste from PDF retain the row/column in excel?

Whenever I copy /paste from a PDF file it turns up all helter skelter in
excel. It soesn't retain the row/column structure of the PDF when pasted in
excel. Perhaps I need to buy a special program. I am using excel 2003, is the
excel 2007 any better?

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default Why won't the copy/paste from PDF retain the row/column in excel?

First, I sincerely doubt that 2007 will act any differently.

Remember that a .pdf file is pretty much a .tif graphic in a special
wrapper. So what you're copying isn't really formatted text, it's a textual
representation of a portion of a graphic that in itself represents some text.

There are darned few tools available that can take a .pdf file and turn it
back into a representation of its original source, be it Word or Excel. The
best one I've found is OmniPage Pro. And it is by no means perfect, but
amazingly better than most I've tried - unfortunately it ain't cheap.

"checkQ" wrote:

Whenever I copy /paste from a PDF file it turns up all helter skelter in
excel. It soesn't retain the row/column structure of the PDF when pasted in
excel. Perhaps I need to buy a special program. I am using excel 2003, is the
excel 2007 any better?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 38
Default Why won't the copy/paste from PDF retain the row/column in exc

I see. The package costs $499.99!

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default Why won't the copy/paste from PDF retain the row/column in exc

Like I said - it ain't cheap. Does lots more than just convert .pdf back to
original type document, but you've got to either really, really want it or
really, really need it. I think I got my version for around $160 on sale, so
keep your eye out, they may go on sale again in the future. I have a need to
use it fairly often as I receive .pdf files that I have to work with in
various ways, and I just got tired of hand typing the darned things, so I'm
"loaded up" with both OmniPage and Adobe Acrobat Pro to deal with them.
And like I said, it's also not absolutely perfect, usually there's some
manual tweaking of the created .doc/.xls or whatever file still to be done.
So in the end, perhaps doing some cut and pasting by hand isn't so bad after
all?

"checkQ" wrote:

I see. The package costs $499.99!

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default Why won't the copy/paste from PDF retain the row/column in exc

Try this one instead

http://www.nuance.com/pdfconverter/

checkQ wrote:

I see. The package costs $499.99!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy column in Excel and paste horizontally in Word. Confused Excel Discussion (Misc queries) 6 March 7th 08 07:22 PM
copy/paste want to retain cell coloration but lose the conditional formatting source data Keith R Excel Discussion (Misc queries) 6 March 5th 07 09:10 PM
Copy contents in a row and paste in a column CJMFH Setting up and Configuration of Excel 1 July 15th 05 03:14 PM
Is there a way to retain a formula while performing cut/paste? Earl Excel Worksheet Functions 1 April 18th 05 10:08 PM
How do I copy and paste Excel charts and retain formatting? Mine . Ivan Lawler Charts and Charting in Excel 2 February 17th 05 01:53 PM


All times are GMT +1. The time now is 08:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"