Change Google Sheet Hyperlinks to Html a h arefs links

  • Resolved mattgusto

    (@mattgusto)


    7 years, 1 month ago

    I’ve installed the Table Press Automatic Url Conversion Extension as I want to put links into my sheets.

    But for the extension to work I Need to change the multiple links in a Google Sheet from normal sheet hyperlinks which like the following:

    =HYPERLINK(“https://traveltractions.com”,”Travel Tractions”)

    I need to convert them into HTML links like;

    <a href="https://traveltractions.com">Travel Tractions</a>

    How can I do this in bulk for sheets so that the plugin will work?

    • This topic was modified 7 years, 1 month ago by mattgusto.

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    Sorry, unfortunately, I do not know a solution to this. This would have to be done in Google Spreadsheets. Depending on what other formulas you have in the table, a simple search/replace for the individual string pieces might work.

    Regards,
    Tobias

Viewing 1 replies (of 1 total)
  • The topic ‘Change Google Sheet Hyperlinks to Html a h arefs links’ is closed to new replies.