Hi All
I am trying to find any word from selected range in my sheet 1 and replace it with another word from a list saved in Master Sheet (Column A - match and Column B- Replace). I found the below code on the net and it works fine, however it replaces even if the word is a part match, which I would like to avoid
For eg :
1. "Narrow" - Correctly Replaces with "Wide"
2. "Narrow Road" - Incorrectly Replaces with "Wide Road" (even if this is not a part of my replacement "Master" Sheet.)
![]()
Please Login or Register to view this content.
Thanks,
Bookmarks