Convert a column of text URLs into active hyperlinks in Excel
Hope you don't want to make a macro and as long as you don't mind an additional column, then just create a new column alongside your column of URLs.Now in the new column type in the formula
=HYPERLINK(A1) (replacing A1 with whatever cell you are interested in).After that, copy the formula down the rest of the 200 entries.
