Convert text URLs into active hyperlinks

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.
Share this article :
 
 
Support : Website Designed | LMSO Group | Organized By
Copyright © 2013. Learning MS Office - All Rights Reserved
Tutorials Developed by LMSO Experts Published by LMSO Group
Proudly powered by LMSO Group