Mass insert Hyperlinks

[kennyb]

Hi,

I am trying to insert many hyperlinks quickly.(at least without having to manually input all of them). I have around 150 line items on my sheet.

Column A is a text string that I want to be the visible in the cell, so people can click on it to activate the hyperlink. (so I do not want the url to be displayed)

column B is the url I want to hyperlink
so, B1 should be the hyperlink for A1 and so on.

Any thoughts?

 

[kennyb]

Nevermind, I just figured it out.
hyperlink formula