Keep hyperlink when referencing that cell.

[jtb1979]

I have a table that contains many links to websites.

I dont like the way its set up and wish to reorganise it.

Instead of copy pasting in order to keep the hyperlinks is there a way for me to reference that cell and still keep the link.

lets say I have a link to a website in A1.
In B20 I want that link to appear. Currently I have to copy and paste it in.
When I put =a1 into b20 all I get back is the text for the hyperlink and not a clickable link.

I cant copy and paste once as the data in the table is changing.

Thanks in advance.

[Moo the Dog]

Couldn't you put this in B20: =HYPERLINK(A1)

- Moo

[dredwolf]

moo's suggestion works, as long as the friendly (displayed) name is the address, not a mnemonic for the link

edit-
or you omit the friendly name...

[jtb1979]

moo's suggestion works, as long as the friendly (displayed) name is the address, not a mnemonic for the link

edit-
or you omit the friendly name...

All links have different text from the address.

[dredwolf]

then you have to either A) delete the friendly text or B) use a look up table for the links ie:
LINKS!A1:A100: address of links
LINKS!B1:B100: friendly text of link

Please Login or Register  to view this content.

or something along those lines

Hope this helps

[jtb1979]

ill try this later.

[dredwolf]

thats fine, and if you wnt the friendly text displayed, this will work:

Please Login or Register  to view this content.

Just so things are balanced

[jtb1979]

Thanks for the replies.

You have inspired with with a fix.

I have a UDF to take the url from a link. So what I now do is use my UDF and then use =Hyperlink(cell containing url,original cell) which gives me what I require in able to format my own permanent layout.

This has bought a nother issue to head though.

Why do hyperlinks always use size 11 font?

Can it be changed to use the font set for that cell?