Hyperlink Text To Display batch edit

[ipbr21054]

Hi,
On my excel sheet i press trl + K which brings up the Insert Hyperlink box.
I have many Hyperlinks on my sheet and i wish to change the text that is in the the field named Text To Display.

As opposed to going through each link & manually editing them is there a batch edit version etc.

I see vba around that will allow certain other Hyperlink issues like this but not the one to do what im asking.

Thanks