Excel cell value equals selected text from Word

  • Thread starter Thread starter sarahphonics
  • Start date Start date
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?
 
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
 
Back
Top