I am hoping to create a formula that will transfer hyperlinks to another cell. I provided very basic pictures to help show somewhat what I mean. But basically whenever I have a function that references a hyperlink in another cell, I just get plain text back - the hyperlink is not preserved in the formula. Is there a way to fix this.
Please let me know if you have any other questions.
Try this in C6:
=HYPERLINK(INDIRECT("C3"))
Ochimus
Try:Formula:
=HYPERLINK("http://"&INDIRECT("C3"))
or optional:Formula:=HYPERLINK("http://"&INDIRECT("C3"),"Google")
or without INDIRECT()Formula:=HYPERLINK("http://"&C3&"")
Last edited by sandy666; 03-31-2016 at 04:28 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks