Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Import Excel data into word as text
I am trying to make form sentences in Word using words from an Excel
spreadsheet. How do I do this, since all the help I see involves putting a table into the file...I am new at this, so please be thorough. I can also see tutorials, if you know of any that willwalk me through tis step-by-step. |
#2
|
|||
|
|||
Select and copy the Excel data you want. Switch to Word. Go to Edit Paste
Special and select one of the text options. "Thomas1024" wrote in message ... I am trying to make form sentences in Word using words from an Excel spreadsheet. How do I do this, since all the help I see involves putting a table into the file...I am new at this, so please be thorough. I can also see tutorials, if you know of any that willwalk me through tis step-by-step. |
#3
|
|||
|
|||
Is there anyway to then have this repeat the form in word, but reference a
new cell in the next "form sentence" Thanks btw "Jezebel" wrote: Select and copy the Excel data you want. Switch to Word. Go to Edit Paste Special and select one of the text options. "Thomas1024" wrote in message ... I am trying to make form sentences in Word using words from an Excel spreadsheet. How do I do this, since all the help I see involves putting a table into the file...I am new at this, so please be thorough. I can also see tutorials, if you know of any that willwalk me through tis step-by-step. |
#4
|
|||
|
|||
You should be able to set up a mail merge maybe.
E.g., Her name is name Her name is name Her name is name Where you have a list of names in Excel and it puts a different one in each sentence. If it is something like that, mail merge will work. See he http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm If that doesn't help, you might want to explain what you need by form sentences. On 2/28/05 8:47 PM, "Thomas1024" wrote: Is there anyway to then have this repeat the form in word, but reference a new cell in the next "form sentence" Thanks btw "Jezebel" wrote: Select and copy the Excel data you want. Switch to Word. Go to Edit Paste Special and select one of the text options. "Thomas1024" wrote in message ... I am trying to make form sentences in Word using words from an Excel spreadsheet. How do I do this, since all the help I see involves putting a table into the file...I am new at this, so please be thorough. I can also see tutorials, if you know of any that willwalk me through tis step-by-step. -- Daiya Mitchell, MVP Mac/Word Word FAQ: http://www.word.mvps.org/ MacWord Tips: http://www.word.mvps.org/MacWordNew/ What's an MVP? A volunteer! Read the FAQ: http://mvp.support.microsoft.com/ |
#5
|
|||
|
|||
On reflection, it does sound as if this is what Thomas is trying to do. Most
likely a "catalog" or "directory" merge is required. The article at http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm is very helpful for Word versions up to Word 2000; the Mail Merge Wizard in Word 2002 and 2003 is a very different interface (sometimes confusing) but accomplishes the same thing. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Daiya Mitchell" wrote in message .. . You should be able to set up a mail merge maybe. E.g., Her name is name Her name is name Her name is name Where you have a list of names in Excel and it puts a different one in each sentence. If it is something like that, mail merge will work. See he http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm If that doesn't help, you might want to explain what you need by form sentences. On 2/28/05 8:47 PM, "Thomas1024" wrote: Is there anyway to then have this repeat the form in word, but reference a new cell in the next "form sentence" Thanks btw "Jezebel" wrote: Select and copy the Excel data you want. Switch to Word. Go to Edit Paste Special and select one of the text options. "Thomas1024" wrote in message ... I am trying to make form sentences in Word using words from an Excel spreadsheet. How do I do this, since all the help I see involves putting a table into the file...I am new at this, so please be thorough. I can also see tutorials, if you know of any that willwalk me through tis step-by-step. -- Daiya Mitchell, MVP Mac/Word Word FAQ: http://www.word.mvps.org/ MacWord Tips: http://www.word.mvps.org/MacWordNew/ What's an MVP? A volunteer! Read the FAQ: http://mvp.support.microsoft.com/ |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difficulty pasting Excel data into Word table only in XP versions | Tables | |||
how to convert wordperfect 5.0 floppy files to word | Microsoft Word Help | |||
multiple docs, one data source | Mailmerge | |||
Converted document from WordPerfect. New footnotes are not being. | Microsoft Word Help | |||
WP Delay Code - Word Equiv | Microsoft Word Help |