Example:
Cell 1: http.standardlink/
Cell 2: [idnumber]
Result: http.standarlink/[idnumber]

Can I make the result a clickable hyperlink, so that I can quickly create a bunch of buttons to links made up of cell 1 and ID numbers?

I know you can manually make each one a clickable link, but I'm looking for a solution where I can simply put in the ID in one cell, and get a clickable link in the next.

I've previously been able to create the text version of a link by combining the values of a cell, but the actual link would have to be copied and pasted into your browser to access.

CodePudding user response：

Yes, you can make. Use HYPERLINK formula with concatenated cells (&) as an argument: =HYPERLINK($A$2&B2)

Result: