how do i get all url's in a column to highlight?

  • Thread starter Thread starter Nick Riffbroker
  • Start date Start date
N

Nick Riffbroker

I made a database of press and radio contacts for my record label. In one
column i list contacts websites. Only some of the url's pasted in are
highlighted and clickable. How do I make all of them clickable?
 
If your URLs are in column A, then in B1 enter:

=HYPERLINK(A1) and copy down to make a nice clickable list
 
Back
Top