+ Reply to Thread
Results 1 to 3 of 3

Convert hyperlinks to HTML

  1. #1
    Registered User
    Join Date
    08-16-2011
    Location
    ottawa
    MS-Off Ver
    Excel 2010
    Posts
    9

    Convert hyperlinks to HTML

    hi there Everyone,

    My problem is that I have to save an .xls file to a .csv file, thus losing the hyperlinking power once i do this. So for example, if there was a link that says "CLICK HERE" and it goes to "www.google.com" all that would be saved on the .csv is the "CLICK HERE". What I would like assistance in is converting all the hyperlinks to the full <HREF= code. So for example, if the hyperlink reads "Executive Assistant" and the hyperlink is to go to another page when clicked then I would like that cell to change to;
    <a href="https://www.google.com" target="_blank">Executive Assistant </a>

    So this would ensure that prior to saving to a .csv I have the code. So when i open the .csv the HTML code is right there in plain text.

    I do appreciate anyone's assistance in helping me with this.
    Last edited by allstarleb; 08-16-2011 at 10:00 PM.

  2. #2
    Registered User
    Join Date
    08-16-2011
    Location
    ottawa
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Convert hyperlinks to HTML

    kinda sad that nobody replied to my request. After searching long n wide I found the answer, incase anyone else needs it;
    getaddress(A1)

    Its that easy... I wish someone responded, it would have saved me a week of trying to find it.

    Ali

  3. #3
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,417

    Re: Convert hyperlinks to HTML

    i understand that you have been able to resolve your query - there is another post which has some very pertinent information, in case you ever need it:

    http://www.excelforum.com/excel-gene...k-formula.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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