EXCEL AND MS WORD...WHY CANT THEY GET ALONG....PLEASE HELP

G

Guest

I have a table in Word that has many rows and cells with text in it.

I have a column of text in excel.

I would like to get in excel the information from the work document of just
the text that is found in my excel column.

I tried vlookup but the document in word may have a sentence in it and vlook
look at a whole cell not part of it.

Thanks for the help very much.

Example: word docuement has "table four is next to table three"
in excel I have a column
 
P

Peo Sjoblom

Your post is cut off, it ends with

"Example: word docuement has "table four is next to table three"
in excel I have a column"

Nevertheless as far as I know you can't do vlookup in Word at all, you need
to copy it over to excel

2. you can use wildcards in a vlookup

=VLOOKUP("*"&A1&"*",Table,2,FALSE)

as an example
 

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

Similar Threads

can I link my Excel Cells to a table in a Word Document 5
Merged Cells when copying a table from Word to Excel 1
Converting word document to excel 1
Word to Excel: Export comments with text and line number 0
Copying a table from Word 5
Excel hyperlink to Word docs 2
how do i copy an excel spreadsheet into word document with a table 1
Excel cell value equals selected text from Word 2

Top