In Excel is it possible to use 'Replace All' function in hyperlinks. Normally, if you do a replace all in excel, it replaces the contents of the cells but not the hyper links. I want to change one particular word in around 100 hyperlinks in one particular master file. Pls use your sources and advise.

Somehow i need to modify the hyperlink text in all the hundred of them.
If there is any VB code that i can run in Visual basic Editor for doing this than please provide it.