Hi everyone

I need a macro to bulk edit a very long list of hyperlink addresses to simply show "OPEN".

Specifically, in Excel I've created a document register where in Column 'A' are the document names and in column 'B' I've inserted the corresponding hyperlink addresses - but I don't want these longwinded addresses to show, just the word OPEN.