Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 18th 05, 06:49 PM
Lisa
 
Posts: n/a
Default Convert Word labels to Excel spreadsheet

I know how to use the mail merge feature from Excel to Word, but how about
from existing labels in Word to a usable Excel spreadsheet. My approaches
have been to save word as .txt and then get external data in Excel. That
works great accept I need to be able to have different column fields like
Name, Address, City, State etc. What is the best way to go about doing this?
Any help?? Thank you in advance.

  #2   Report Post  
Old January 18th 05, 10:06 PM
Myrna Larson
 
Posts: n/a
Default

How about reformatting the Word document to put all of the information from
one label on a single line, separated by tabs. Then you could import that into
Excel.

On Tue, 18 Jan 2005 10:49:11 -0800, "Lisa"
wrote:

I know how to use the mail merge feature from Excel to Word, but how about
from existing labels in Word to a usable Excel spreadsheet. My approaches
have been to save word as .txt and then get external data in Excel. That
works great accept I need to be able to have different column fields like
Name, Address, City, State etc. What is the best way to go about doing this?
Any help?? Thank you in advance.


  #3   Report Post  
Old January 18th 05, 10:36 PM
 
Posts: n/a
Default

Thank you for responding. I am not sure how to get them out of the
three column lable template into nice neat rows in word. I have
converted table to text and then they are inthe format of an address
label still. I need to get all the names and addresses into rows
somehow. Any ideas how to do that?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to link an Excel spreadsheet to a Word document an. Infinity Excel Discussion (Misc queries) 1 December 14th 04 03:30 PM
how do i convert a word document to excel Ian Excel Discussion (Misc queries) 2 December 13th 04 12:54 PM
how do i import an excel spreadsheet to a word document gmoney Excel Discussion (Misc queries) 2 December 7th 04 04:11 PM
How to convert the table in word to excel sheet? Santhosh Excel Discussion (Misc queries) 1 December 2nd 04 10:15 AM
Copying an Excel spreadsheet to a Word document KG Excel Discussion (Misc queries) 1 November 28th 04 07:38 PM


All times are GMT +1. The time now is 06:28 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017