How to make links from one column in another Excel?

D

D

Darklt2020-02-28 12:12:37

excel

Darklt, 2020-02-28 12:12:37

How to make links from one column in another Excel?

There is column A with links, and there is column B with names

how to stretch links from column A to column B??

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

2 answer(s)

F

FAN2 tom, 2020-02-29
@FAN2tom

If in column A, it says " A ", and in B " B ", then if you enter "=CONCATENATE(A1;" ";B1)" in column C, we get " A B "
But this only works with text!

F

Fodin, 2020-03-02
@Fodin

Column B will not work right away, but in cell C1 you can write = HYPERLINK (A1; B1) and multiply by column C.

Similar questions

I

IVBAN2021-06-09 09:42:05

How to remove autoscroll in excel according to cell size? 1Reply

C

cicatrix2021-06-09 11:19:18

Find a cell in a range with a maximum value that does not exceed a given criterion? 1Reply

G

ghostkhimki20152021-06-12 21:25:28

VBA Excel how to correctly make a macro to determine N - the number of xi with even numbers less than x1 and xmax / 2? 1Reply

D

Dmitry2020-04-21 13:45:26

Address distribution of the certificate of participation in the event? 0Reply

S

szx2018-02-12 08:30:30

How to correctly put the current time and date in an Excel cell? 0Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question