When I copy table data into excel, it ONLY pastes it into column A! How to fix this?

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?

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.

1. Paste your data into the first column.
2. Select the data that was pasted into column A.
3. Click on Data -> Text to Columns in the toolbar.
4. Select delimited, click next.
5. Check Space box under delimiters, click next.
6. Customize column data types if needed. Click finish.

Hope this helps.