When I copy table data into excel, it ONLY pastes it into column A! How to fix this?
Save the PDF to your computer and open it in Adobe Reader. Hold the Alt key while selecting it (this allows you to use marquee/table select), then copy and paste it into Excel.
I was able to get this to work in Excel 2010.
- Paste your data into the first column.
- Select the data that was pasted into column A.
- Click on Data -> Text to Columns in the toolbar.
- Select delimited, click next.
- Check Space box under delimiters, click next.
- Customize column data types if needed. Click finish.
Hope this helps.