Extracting hyperlinks

  • Thread starter Thread starter =?iso-8859-1?Q?Mattias_Palmest=E5l?=
  • Start date Start date
?

=?iso-8859-1?Q?Mattias_Palmest=E5l?=

I have a worksheet which in one column contains
hyperlinks, but now I would like to copy just the
hyperlink adress to another column. Of course I could
just manually get the adress and copy-paste, but since
there are some 4000 links, I would rather do this in a
more effective way... Is this possible?
 
Hi,

Supposing a hyperlink is in cell A1; in cell B1 enter the formula "=A1"
(without quotes) and drag down.

Amit
 
Back
Top