If I use the following link:
http://web.utk.edu/~dhouston/excel/exam1.pdf
to copy the table and paste it into excel, it will only paste the values into one long column in Column A (and each row has a value).
So Column A, Row 1 is Year, Column A Row 2 is All Families, etc. I used to be able to paste the text and it would stay in the table format (even if they weren't split into cells).
How do I solve this issue?
Best Answer
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.