Convert hyper link to text

[simon11]

I am trying to write a macro which will extract a hyperlink form a cel
and paste it as text in an adjacent cell. This I have acheived howeve
I have 17000 entries for which to apply this macro to so am looking fo
a soltuion for the macro which will enable me to do this in 1 attempt

 

[David McRitchie]

Hi Simon,
Rather than that, I would suggest using a User Defined Function,
so that can put the hyperlink text anywhere, and so that it update
automatically. See HyperlinkAddress in
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#hyperlinkaddress

You can double-click on the fill handle to copy formula down
http://www.mvps.org/dmcritchie/excel/fillhandle.htm