Word to Excel Conversion Office 2007

J

JohnH

I have a word file with name-address info in the following format that I woul
like to convert to an eacel file

Word File

John Doe
President
ABC Co
City
State
Zip

Mary Smith
CEO
XYZ Co
City
State
Zip

repetes many times

I'd like to convert it to excel as
Name Title City State Zip

Each field/line in its own cell.

Any help is greatly appreciated.

Thanks
John H
 
G

Graham Mayor

See http://www.gmayor.com/convert_labels_into_mail_merge.htm and jump in
where the illustrations match your format. Essentially this means selecting
the document and converting text to table (7 columns) then convert table to
comma delimted text, which Excel will open as a table.

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


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top