Give this a try in Excel:
In an adjacent column enter the formula =HYPERLINK(A1) , where A is
the column containing the addresses. This will turn it into a
hyperlink.
Then copy that cell,
Then select the rest of the column below that cell
Paste. You should now have a column of URLs just like the existing
column, only clickable.
In an adjacent column enter the formula =HYPERLINK(A1) , where A is
the column containing the addresses. This will turn it into a
hyperlink.
Then copy that cell,
Then select the rest of the column below that cell
Paste. You should now have a column of URLs just like the existing
column, only clickable.