ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   word addresses (https://www.excelbanter.com/excel-discussion-misc-queries/175627-word-addresses.html)

Windy

word addresses
 
someone gave me a list of addresses in word - how can i change those to excell?

Jim Thomlinson

word addresses
 
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...
--
HTH...

Jim Thomlinson


"Windy" wrote:

someone gave me a list of addresses in word - how can i change those to excell?


krakatoakt

word addresses
 
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


"Windy" wrote:

someone gave me a list of addresses in word - how can i change those to excell?


MrAcquire

word addresses
 
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.

"Windy" wrote:
someone gave me a list of addresses in word - how can i change those to excell?


MrAcquire

word addresses
 
Copy and paste will do the same thing.

"MrAcquire" wrote:

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.

"Windy" wrote:
someone gave me a list of addresses in word - how can i change those to excell?



All times are GMT +1. The time now is 11:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com