PDA

View Full Version : Solved: Move numbers from DOC to XLS



Saladsamurai
05-31-2010, 03:39 PM
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
05-31-2010, 04:09 PM
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
05-31-2010, 04:14 PM
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
05-31-2010, 04:19 PM
I'm on a Mac, using Excel 2004.

On mine its under Data on the menu.

Saladsamurai
05-31-2010, 04:30 PM
Never knew about that feature! Learn something new each day :)

Thanks a bunch!
Casey