Tips And Guide

Convert a column of text URLs into active hyperlinks in Excel

Hope you dont want to make a macro and as long as you dont 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.