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

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - how do i get all url's in a column to highlight? (https://www.excelbanter.com/new-users-excel/185663-how-do-i-get-all-urls-column-highlight.html)

Nick Riffbroker

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

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?

Gary''s Student

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

If your URLs are in column A, then in B1 enter:

=HYPERLINK(A1) and copy down to make a nice clickable list
--
Gary''s Student - gsnu200782

"Nick Riffbroker" wrote:

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?

All times are GMT +1. The time now is 06:01 PM.