Thank you for the information, I'll give it a try - after spending over $300 on Acrobat Standard X.

Yes I too found the copy and paste in Acrobat 9 functional , upgraded to X which has been a huge waste of money. I started with Acrobat 4.0 and usually each version provided better features until now hopefully someone at Adobe monitors these posts and will provide a fix in the future. Will probably have to uninstall Version X and reinstall 9

Had I known that at the time would have been worth it as it was when I went to install X it told me to unistall the old version and when I did and then tried to run X it said I couldn't upgrade because it couldn't find a current version on my computer so had dig out the old copy so that the X would install and give me credit for owning a previous version. So far haven't seen X do anything better than version 9 for the purposes I use it for. I'll try installing 9 back over the top of X , thanks for the tip.

Appreciate the offer but the file is from an insurance company and the client information is protected so I can’t release. But when we use copy or copy format it puts it in an entirely different format in the excel spread sheet either all data in one column or in formatted in several columns but still the data is combined where as when you use copy as a table in Acrobat 9 it lays it out perfectly in excel just like in the pdf. After using Acrobat X now for a couple of weeks definitely wasn’t worth upgrading from 9.0 to X. Thanks for the offer though.

Thanks for the response however I've tried this and it just doesn't work right, after having worked with Acrobat X even more it just isn't as good as 9.0, documents I used to be able to OCR now have more unrecognized or miss recognized items than 9.0 and the only thing I have changed is going from 9.0 to 10.0. This appears to have been nothing but a profit move from Adobe just a few bells and whistles. This is the first time Adobe has failed to deliver a significant improvement by introducing a new version and I started with 4.0

I have discovered a work around.  Select the table you are trying to copy, right click and select "export selection as" and save it as a .docx file.  Open the word document, copy the table again and paste it into an open excel file.  The columns will be maintained and your data will be in seperate cells instead of all of it in one cell.  It's not one easy step like it used to be, but it does work.