How do I convert a column of text URLs into active hyperlinks in Excel?
If 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. In the new column type in the formula =HYPERLINK(A1) (replacing A1 with whatever cell you are interested in). Then copy the formula down the rest of … Read more