CODEWITHSUNDEEP
excelhyperlink
Garrett
Garrett

Reputation: 649

excel hyperlinks containing data from another cell

I have a list of serial numbers in a column and I would like to create a hyperlink in a different column to a website that will contain the serial number found in the corresponding cell. For example:

enter image description here

Is there a way to input a formula using the hyperlink fx? Something like =HYPERLINK(www.website.com/[A2]?

Upvotes: 0

Views: 37

Answers (1)

BigBen
BigBen

Reputation: 49998

Just concatenate with &:

=HYPERLINK("www.website.com/" & A2)

You can concatenate more text if needed:

=HYPERLINK("www.website.com/" & A2 & "/search")

Upvotes: 1

Related Questions