Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2004

Tip: Looking for answers? Try searching our database.

Moving data from Word to Excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
^^Patty^^ - 31 Oct 2004 03:29 GMT
I need to move a list of address from Word to Excel so I can import the Excel
data file into a shared Outlook address book.   I can simply Copy & Paste,
but how can I set up the Excel worksheet so that it will import  correctly
into Outlook?  TIA
VENKAT - 31 Oct 2004 05:31 GMT
dependsupon how the addrsses are configred in MS word
If the addresses are in lines for e.g.

venkat 28 sadulla street t.nagar
rajaraman bajajapts nandanam ext

In that case highlight all the addresses and click edit copy
and go to excel highlight any cell and click paste
each address will be in the first column
assuming as in the above example there are spaces between the   words of  
the address then
highlight the first column of addresses and click data-text to columns and  
use delimiter as <space> and click finish you will get each word in  
differnt columns.

If each word inthe address is in different columns of a table in WORD then  
select the whole table and copy and paste to excel. in this connection see  
help in excel "Copy a Word table onto a Microsoft Excel worksheet"

a few experiments will give you a hang of it.

> I need to move a list of address from Word to Excel so I can import the  
> Excel
[quoted text clipped - 3 lines]
> correctly
> into Outlook?  TIA

Signature

Using Opera's revolutionary e-mail client: http://www.opera.com/m2/

^^Patty^^ - 31 Oct 2004 14:54 GMT
Thank you.  I'll play around with it.  

> dependsupon how the addrsses are configred in MS word
> If the addresses are in lines for e.g.
[quoted text clipped - 24 lines]
> > correctly
> > into Outlook?  TIA
David McRitchie - 31 Oct 2004 05:43 GMT
Hi Patty,
Try Exporting your Outlook Address book to a CSV file, read that file with
Excel and you will have the titles that you need as long as you include all
of the fields that you are actually using.

Before trying anything be sure to back up your address book (.WAB)
 http://www.mvps.org/dmcritchie/excel/backup.htm
You will probably have to restore it during your efforts.

I did this a long time ago my notes are at
  http://www.mvps.org/dmcritchie/excel/ofc2000.htm
look for   Conversion of AOL Address book
(if anyone is actually doing that conversion now there are utilities
specifically for that purpose).

After you copy the data from Word with Copy and Paste,  you will
need to move columns around and retitle  row 1.
To move columns around see
     http://www.mvps.org/dmcritchie/excel/fillhand.htm
Practice on a copy of your worksheet so you have backup and so you don't
lose your data,  but the technique  is as follows  .,..

Move a Column(s) and insert between columns without losing data,
 Select a column, hold the SHIFT key, and grab the side of the column below
 the column headers (A,B,C) and drag it left or right to move, you wiil see a single
 line following the cursor, drop it between existing columns.

---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

> I need to move a list of address from Word to Excel so I can import the Excel
> data file into a shared Outlook address book.   I can simply Copy & Paste,
> but how can I set up the Excel worksheet so that it will import  correctly
> into Outlook?  TIA
^^Patty^^ - 31 Oct 2004 14:55 GMT
Thank you.  That will give me a few things to work with.  

> Hi Patty,
> Try Exporting your Outlook Address book to a CSV file, read that file with
[quoted text clipped - 33 lines]
> > but how can I set up the Excel worksheet so that it will import  correctly
> > into Outlook?  TIA
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.