I tried downloading that excel and doc but that are in xlsx and docx format so cant open that and see, but the issues could be solved like this, but here I have doubt once the link is not there , wont the replace changes again into original?

I am attaching both files for your reference, where test 1....test 3 etc are need to be worked upon,

Here to make it use ABLE for any find and replace text, macro should ask the text first, and while coping and pasting again in word from excel, it must ask if that is required word, else find next and replace with corresponding value,

Attached Files

	Book1.xls (13.5 KB, 9 views)
	test.doc (19.5 KB, 9 views)