How to insert a link into a cell using a formula?

A

A

Alexey Golovin2022-01-13 05:18:43

Google Sheets

Alexey Golovin, 2022-01-13 05:18:43

How to insert a link into a cell using a formula?

How can I use a formula or a script to take a link from cell A3 and paste it into cell A1, while the text should remain in cell A1?

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Alexander, 2022-01-13
@dadduUrsa

First use the HYPERLINK function , and then the clipboard (copy-paste).
In the next column or on another sheet in cell C1 write:
=HYPERLINK(A3;A1)
Then copy and paste into column A as values.

Similar questions

A

Artemiy_P2021-02-27 19:24:29

How to fix TypeError: Cannot read property '0' of null? 0Reply

B

by_EL2021-02-28 15:37:14

How can I make cells linked by the IMPORTRANGE() function so that they can be changed? 0Reply

N

Noir2019-07-31 11:49:47

How to find out what format? 3Reply

A

Alexander Andreev2017-03-14 13:55:37

How to get the contents of a sheet/tab of a table on google docs? 0Reply

T

trazer912021-03-11 15:30:14

We need a macro that, when executed, will copy the string and paste its values below into a free string. How to do it? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question