+ Reply to Thread
Results 1 to 2 of 2

Convert list of text links into Hyperlinks?

  1. #1
    Registered User
    Join Date
    austin, tx
    MS-Off Ver
    Excel 2010

    Convert list of text links into Hyperlinks?

    Dear forum member:

    I have list of text links which I want to convert to hyperlinks.

    I copied and pasted the html code into a notepad, then I removed html tags and kept only 2 columns with a comma between 2 columns.

    example of comma separated text: www.ajli.org,www.ajli.org

    I imported .txt file into excel 2010, then modify each column as ‘text’. I used a Marco to convert text links. I followed these 2 links to import .txt file then use a Marco to convert text link into hyperlink. After conversation, I click on the link, it says “Can’t open specified file”.

    import .txt into excel
    please give me some advise to fix the issue. Thanks!

  2. #2
    Registered User
    Join Date
    MS-Off Ver
    Excel 2007

    Re: Convert list of text links into Hyperlinks?

    It appears that the script you used converts the text to a link to a file so when clicking the link it looks for the file on your computer not a website. The suggested alternative that is posted in the comment section of the same website http://www.jerryleventer.com/excel-t...to-hyperlinks/:

    Jerry Leventer // Sep 14, 2011 at 11:02 pm

    Please try this:

    Please Login or Register  to view this content.
    Does this help?


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1