CODEWITHSUNDEEP
excelmergehyperlink
Sergio Gentile
Sergio Gentile

Reputation: 11

Merge links with text without changing text

I have Web links in one column and plain text in another.

I would like to merge the links from A to B without B changing name.

(Basically want to move in the links without changing the name of the original cells.)

Upvotes: 0

Views: 4939

Answers (2)

RugerSR9
RugerSR9

Reputation: 458

You're going to have to set a formula for the cells with names on them.

1) Copy the entire column of names to a different column.

2) Add this formula to the first few names of the new column. =HYPERLINK(linklocation,namelocation)

3) Select the entire column of the copied names.

4) Use the "Fill" tool and fill down. Done.

Example:

enter image description here
(source: gyazo.com)

Upvotes: 0

Netloh
Netloh

Reputation: 4378

If you want to do the merge in a third column (for example the C column), you can do this fairly simple with the HYPERLINK function. Try to use the following in cell C1:

=HYPERLINK(A1, B1)

Upvotes: 1

Related Questions