CODEWITHSUNDEEP
google-sheetsformulagoogle-sheets-formula
datazang
datazang

Reputation: 1169

How to build a dynamic hyperlink in Google-Sheets?

I have data that contains only one column. I simply want to create a new URL column based on this column. 

   id     url 
  1234   https://www.xyz.ne/1234
  2984   https://www.xyz.ne/2984
  1222   https://www.xyz.ne/1222
  2341   https://www.xyz.ne/2341
  5959   https://www.xyz.ne/5959

But I want to add an URL to a new column like this: https://www.xyz.ne/id

How can I do this?

Upvotes: 0

Views: 1799

Answers (1)

JvdV
JvdV

Reputation: 75840

Hm, maybe the following will do it dynamically for your whole range, no need to enter specific ranges. So type in B2:

=ARRAYFORMULA(HYPERLINK("https://www.xyz.ne/"&FILTER(A2:A,A2:A<>"")))

Upvotes: 4

Related Questions