Convert hyperlinks to HTML

hi there Everyone,

My problem is that I have to save an .xls file to a .csv file, thus losing the hyperlinking power once i do this. So for example, if there was a link that says "CLICK HERE" and it goes to "www.google.com" all that would be saved on the .csv is the "CLICK HERE". What I would like assistance in is converting all the hyperlinks to the full <HREF= code. So for example, if the hyperlink reads "Executive Assistant" and the hyperlink is to go to another page when clicked then I would like that cell to change to;
<a href="https://www.google.com" target="_blank">Executive Assistant </a>

So this would ensure that prior to saving to a .csv I have the code. So when i open the .csv the HTML code is right there in plain text.

I do appreciate anyone's assistance in helping me with this.