View Single Post
  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default activate column of URLs as hyperlinks

Depending on what's in those cells, you may be able to use another column of
cells with formulas in them:

=hyperlink(b1)
or
=hyperlink("http://" & b1)
or
=hyperlink("http://" & b1, "Click me")

And then drag down the column.

wrote:

I'm sorry, I don't understand. Currently they aren't hyperlinks, just a
text column of URLs. I want them to be activated and don't know how.


--

Dave Peterson