'Google Sheets - How to parse link with data from another cell?

Basically, cell A has an ID number in it. I want the adjacent cell B to contain a link to that ID page on my website. So for example, | 938294839 | website.com/938294839 | Is there anyway to automatically generate the link based off info in another cell?

google-sheets

Solution 1:^[1]

Just assemble the string:

A1   |  B1
----------
stem | =concat("https://website.com/", $A1)

Sheets will detect the resulting link for you.

Solution 2:^[2]

all you need is:

="https://website.com/"&A1

for array it would be:

=ARRAYFORMULA("https://website.com/"&A1:A10)

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	2e0byo
Solution 2	player0

'Google Sheets - How to parse link with data from another cell?

Solution 1:[1]

Solution 2:[2]

Sources

Related Questions

Solution 1:^[1]

Solution 2:^[2]