Import Excel data into word as text

T

Thomas1024

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.
 
J

Jezebel

Select and copy the Excel data you want. Switch to Word. Go to Edit > Paste
Special and select one of the text options.
 
T

Thomas1024

Is there anyway to then have this repeat the form in word, but reference a
new cell in the next "form sentence"

Thanks btw
 
D

Daiya Mitchell

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 here:

http://word.mvps.org/FAQs/MailMerge/CreateAMailMerge.htm

If that doesn't help, you might want to explain what you need by form
sentences.
 
S

Suzanne S. Barnhill

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/CreateAMailMerge.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.
 

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