Solved: Move numbers from DOC to XLS

[Saladsamurai]

Hey folks!

So I have this word document that I copy-pasted from an online pdf file. When I try to paste these numbers into an excel file, weird things happen since excel cannot detect the delineation (because I don’t think there is any). I would just like to write a VBA script that can help me pull these numbers into a workbook. Each row in the word document should be a new row in the Excel file. I think this should be straight formward, but my VBA skills are very rusty.

.DOC attached.

Thanks,
Casey

[mikerickson]

Copy from Word
Paste into Excel
TextToColumns with a space delimiter

worked for me.

Is it just this file, or do you have a bunch of them?

[Saladsamurai]

Just this one. Where does the texttocolumns option appear? Under paste special? It might be that I am not seeing it because I am on mac at the moment. You using excel 03 or a newer version?

[mikerickson]

I'm on a Mac, using Excel 2004.

On mine its under Data on the menu.

[Saladsamurai]

Never knew about that feature! Learn something new each day

Thanks a bunch!
Casey