Mass renaming hyperlinks

Hi all,

I have a very simple sheet in Excel

Column A contains a title for a document, and Column B contains a hyperlink to that document which displays the full file path.

I would like to rename all of the hyperlinks to have the name as per Column A, but I've forgotten everything I knew (which wasn't a lot) about Excel and how to automate that.

Could someone point me in the direction of a working Macro for this?

Many thanks indeed,

Ben!