Thanks so much, your reply brings me closer than ever before and is so simple, but I need the text to be replaced with the same text but hyperlinked to the hyperlink, so "Newsletters" becomes "Newsletters" (hyperlinked)

but the method below replaces the word text with the url.

Any more suggestions?

Thanks again


Hi Synthia,

Copy you hyperlink to the clipboard, the use Find/Replace, where:
Find = newsletters
Replace = ^c