# 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!

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

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.

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:

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

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