Copy hyperlink values to new cell

**Mike_Gormley** · 10-14-2009, 07:43 PM

I have a long series of cells that are hyperlinked. The text displayed in the cell is NOT the hyperlink. Is there any way to paste the value of the hyperlink into another cell? Is there a function or macro that can extract the hyperlink and place it in a new cell?

**NBVC** · 10-14-2009, 08:16 PM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**Mike_Gormley** · 10-15-2009, 09:48 AM

I have attached a sample data workbook. The domains and email addresses are for sample purposes only, and do not represent real data.

The hyperlink does not have any common structure other than the domain, the code after .com is unique to each record.

Your help is greatly appreciated.

**NBVC** · 10-15-2009, 03:18 PM

You can use a simple user defined function..

Here is one gotten from here: http://www.ozgrid.com/VBA/HyperlinkAddress.htm

Please Login or Register  to view this content.

To use it, Hit Alt+F11 to go to VB editor..

Go to Insert|Module and paste above code...

Back in your worksheet, enter formula: =GetAddress(A3) and copy down..

**iamprabhakaram** · 11-14-2012, 05:21 AM

Dear NBVC
this is datta form Hyderabad
i want to copy hyper link to other cell (form column A to Column C) how can i i have 10250 Rows to copy like this pls help on this

**arlu1201** · 11-14-2012, 05:24 AM

Datta,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.

**NICO PRINSLOO** · 07-18-2015, 11:51 AM

Hyperlinks in sheet 1 a1:a10
all 10 hyperlinks target sheet 2 a1
if any hyperlink in sheet 1 are selected
data of that cell to be written into sheet 2 a1
sheet 1 a1 = aa then sheet 2 a1 = aa
sheet 1 a2 = bb then sheet 2 a1 = bb
and so on

**newdoverman** · 07-18-2015, 02:02 PM

Welcome to the forum. Unfortunately you have posted a question in someone else's thread. This is called "hijacking" and is against the rules.

Your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.