Excel cell value equals selected text from Word

S

sarahphonics

Is it possible to bookmark or link a piece of text in Microsoft Word eg. a
title in the word document is 'West Belfast Profile'
In Excel, I would like to make a cell value equal to the text from Word.

Basically cell A5 in excel equals 'West' from the title 'West Belfast
Profile' in Word. If the user changes the title in Word to 'East Belfast
Profile', the cell value in Excel changes to 'East'.

Is this possible?
 
L

Lee Li Fong

You go to Word document and copy the text you want to link to Excel, select the cell you want to paste to Excel file, right-click and select paste special, select paste link, select text, ok. When you change the text in Word, it should can link in Excel now

Lee Li Fon
http://smartusemicrosoftoffice.blogspot.com
 

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

Copying data from one workbook to another dependent on user select 1
drop down list 2
Grabbing Formula Information from Another Cell 7
If condition with text 3
Questionnaire using Excel 3
how do I test for a text value in cell c1, if it is there, make c. 1
cell on sheet 1 equals cell on sheet two 2
insert document properties text in a cell 2

Top