Moving data from Word to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 
Thank you. I'll play around with it.

VENKAT said:
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.
Click to expand...
 
Back
Top