CODEWITHSUNDEEP
excelexcel-formulahyperlink
Xtreambart Bart
Xtreambart Bart

Reputation: 11

I need a cell to be a hyperlink and the content from the cell a part of the hyperlink

I need a cell to be a hyperlink and the contents of the cell is part of the hyperlink. So in the link under, I added the line CELLCONTENT and that is the part in the hyperlink that should change when i click a cell, the content of the cells is like C1234-1234

https://text.text.text.net/text/ViewPII.jsp?pii_id=VPROC009105&pii_name=CELLCONTENT&config_week=202017&top_line=VCC1191186&end_item=PRG-VCC42&release_status=Published

So if i click the cell, the link should be (and also go to the site)

https://text.text.text.net/text/ViewPII.jsp?pii_id=VPROC009105&pii_name=C1234-1234&config_week=202017&top_line=VCC1191186&end_item=PRG-VCC42&release_status=Published

This is what i tried enter image description here

Upvotes: 1

Views: 56

Answers (1)

chris neilsen
chris neilsen

Reputation: 53126

Hyperlink expects a string representing the destination to link to.

Should be something like

=Hyperlink("https://text.text.text.net/text/ViewPII.jsp?pii_id=VPROC009105&pii_name=" & F2 & _
  "&config_week=202017&top_line=VCC1191186&end_item=PRG-VCC42&release_status=Published", "Text To Display In Cell")

where cell F2contains part of the link string.

Upvotes: 1

Related Questions