How to remove hyperlink anchors in xlsx, xml tables?

Question

Search Engine Optimization

Hey!
Already my head hurts and Google cannot help (maybe I’m not entering the request correctly). In general:
There are price lists of suppliers whose hyperlink to a photo has an anchor like "Photo" or "Picture".
The problem lies in the inability of the module to parse data by reference.
Task: remove the anchor from all hyperlinks so that just a link remains in the cell.
Tell me how to do this, maybe someone has already come across ... I know exactly what is possible with the help of a macro or functions, but I don’t understand how / what / where to register to get the result.

Answer 1

Here is the solution: manaeff.ru/forum/viewtopic.php?f=14&t=977
Here is the macro instruction: exceltip.ru/%D0%BA%D0%B0%D0%BA-%D0%BD%D0%B0%D0 %BF%...
And also as an option - www.excel-vba.ru/chto-umeet-excel/kak-poluchit-adr...
Solution of the issue thanks to the kind forum members Dmitry and DS28 . Thank you very much!!