W
Windy
someone gave me a list of addresses in word - how can i change those to excell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jim Thomlinson
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...
lot on what the addresses look like in word as to how much luck you will have
getting them into XL...
K
krakatoakt
Windy,
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.
~ Krakatoakt
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.
~ Krakatoakt
M
MrAcquire
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.
then operate on it (macros, formulas, cut/paste, etc.) to get the desired
spreadsheet format.
M
MrAcquire
Copy and paste will do the same thing.
MrAcquire said: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.