Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL AND MS WORD...WHY CANT THEY GET ALONG....PLEASE HELP
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL AND MS WORD...WHY CANT THEY GET ALONG....PLEASE HELP
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 -- Regards, Peo Sjoblom "pam" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Reflecting info between an excel file and a word one or two excel file. | Excel Discussion (Misc queries) | |||
Print Excel charts in Word 2003 with fixed size | Charts and Charting in Excel | |||
Excel date field link to Word | Excel Discussion (Misc queries) | |||
Can Excel Export Data to Word Format? | Excel Discussion (Misc queries) |