How do I export addresses from Word to Excel?

[Rafael H]

I have a list of contacts in general text format in word and I want to export
that info to Excel to different columns. In Word, its in this format:
Company
Contact
Address
city state zip
phone
email

Is this possible?

 

[Robert M. Franz (RMF)]

Ciao Rafael

I have a list of contacts in general text format in word and I want to export
that info to Excel to different columns. In Word, its in this format:
Company
Contact
Address
city state zip
phone
email

if this is really the format of your entries, with no empty lines (where
a certain info is missing) and no empty paragraphs between one contact
and the next, then it's really easy to convert it into a table in Word
and then copy/paste it into Excel.

Select the whole stuff, then use Table | Convert | Text to table: 6
columns, «OK».

If you need to separate city/state/zip into three different columns, I'd
deal with that in Excel. A matter of taste maybe, but you can certainly
split it there with a formula.

HTH
Robert

 

[Graham Mayor]

See http://www.gmayor.com/convert_labels_into_mail_merge.htm and jump in
where the illustrations match your document.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>