Have you tried copy and paste. When you did that what happened. It depends a
lot on what the addresses look like in word as to how much luck you will have
getting them into XL...
After you copy the addresses in Word go into the Excel sheet and right
click. Utilize the Paste Speical options in Excel to see if they provide what
you need.
One way is to save the Word file as a text file, parse it into Excel, and
then operate on it (macros, formulas, cut/paste, etc.) to get the desired
spreadsheet format.
One way is to save the Word file as a text file, parse it into Excel, and
then operate on it (macros, formulas, cut/paste, etc.) to get the desired
spreadsheet format.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.