How do I export addresses from Word to Excel?

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

Guest

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?
 
Ciao Rafael

Rafael said:
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
Click to expand...

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
 
Back
Top