How to convert url text to clickable hyperlink in Excel?

How to convert url text to clickable hyperlink in Excel?

Supposing you have multiple urls in your worksheet, but they are not linked, and now you need to convert all the unlinked urls to clickable hyperlinks, as following screenshots shown. Of course, you can double click them one by one to make them clickable, but this will be time consuming if there are lots of urls. How could you convert multiple unlinked urls to clickable hyperlinks automatically in Excel?

via How to convert url text to clickable hyperlink in Excel?.

More tips:
http://stackoverflow.com/questions/2595692/how-do-i-convert-a-column-of-text-urls-into-active-hyperlinks-in-excel

Leave a Reply