Excel – How to turn plain text links into hyperlinks in excel

microsoft-excel-2013

I have a list of links in an Excel spreadsheet that I want to turn into hyperlinks so I can view them in a web browser. Is there a way I can change all of them to hyperlinks at once? I'm using Excel 2013. Thanks for your help!

Best Answer

No need to do any programming or go to another app to fix this.

TEXT link to Clickable Hyperlink in EXCEL

Add a New Column next to your column of text links

If your text link is www.example.com (no http://):

  • Paste this formula into the cell of your new column next to your original column of TEXT that you want to change to a clickable hyperlink.

    =HYPERLINK("http://"&A2)

    The last two characters before the close parens is the target cell / whatever column and row has the text link

    You can copy this formula down the NEW column and you are all set

If you text link is http://www.example.com:

  • Add the new column

    If the http:// is already in the text itself Just past this into the cell next to your text link and it should work

    =HYPERLINK(A2)

    The last two characters before the close parens is the target cell / whatever column and row has the text link

    You can copy this formula down the NEW column and you are all set