How to add a URL to a column with a formula?

Question

excel

Made gluing 3 columns using the "link" formula.

Task: to make the result clickable. I clicked on the link.

PS: It is important that the link is generated automatically when filling in the phone number.

You can do the same with Google Sheets.

Answer 1

Use the HYPERLINK () and CONCATENATE () functions , or the & concatenation . You can additionally make a mass formula using ARRAYFORMULA ()

=ArrayFormula(ЕСЛИ(A1:A="";"";ГИПЕРССЫЛКА(A1:A&B1:B&C1:C)))

Demo table

Answer 2

Wrap the concatenate formula in IF and HYPERLINK

Answer 3

Place your formula inside the HYPERLINK function.