CODEWITHSUNDEEP
excelvbahyperlink
Andy
Andy

Reputation: 11

Adding hyperlinks

Surely this can be done easily if you know how to write a macro, sadly I don't so I'm bothering you.

What I'm trying to do is adding a hyperlink to a cell (the link does not change other than the numbers at the end of it, which I have written down in the same cell I'm adding a hyperlink)

I've tried a simple keyboard macro by Copying the cell with the numbers > CTRL+K and writing the Hyperlink part that doesn't change, and pasting the numbers that were copied. However it doesn't work as planned, Excel copies the cell but after pressing CTRL+K it gets removed from the clipboard, Am I doing something wrong or is this something that can be done?

The link that never changes is: http://myanimelist.net/anime/ [The numbers in the sheet goes after /anime/]

Typing it all by hand is simply out of the question, I have close to 5,000 lines to add hyperlink to.

Upvotes: 0

Views: 203

Answers (1)

Jose Cherian
Jose Cherian

Reputation: 7727

You don't need a macro to do that. just use the below formula on the first row and use auto fill to fill the formula to remaining rows. This formula assumes your numbers are in column A.

=HYPERLINK(CONCATENATE("http://myanimelist.net/anime/",A1),A1)

Upvotes: 1

Related Questions