Extracting hyperlinks

  • Thread starter Mattias Palmestål
  • Start date
M

Mattias Palmestål

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?
 
S

Someone

Hi,

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

Amit
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlinks with lookups 0
Can UDF return a customized hyperlink? 3
Copy addition formula of non-consecutive horizontal cells 2
List all tables, including document structure 0
New computer, how do i move outlook 365 ENTIRELY? 0
extract hyperlink with worksheet 0
Autonumber field in Excel that behaves the same as Access 0
Copy hyperlinks 6

Top