Excel convert hyperlink formulas to links with friendly names
<p>I need to convert columns of cells with HYPERLINK formulas into cells with just the friendly_name hyperlinked to link_location.  For instance, =HYPERLINK("<a href="https://www.google.com/search?hl=en&amp;q=" rel="nofollow">https://www.google.com/search?hl=en&amp;q=</a>"&amp;SUBSTITUTE(A2," ","+")&amp;"&amp;tbm=isch&amp;gws_rd=ssl","G images") to a cell that just has G images in it and is hyperlinked to the hyperlink that the formula produces, e.g. <a href="https://www.google.com/search?hl=en&amp;q=search+term&amp;tbm=isch&amp;gws_rd=ssl" rel="nofollow">https://www.google.com/search?hl=en&amp;q=search+term&amp;tbm=isch&amp;gws_rd=ssl</a>.  I can do this by pasting into Word and pasting back into Excel, but I need to do it within Excel, whether by some copy/paste trick or a macro.</p>