KB1901176

KB1901176: Improved support for =HYPERLINK( ) function links and labels

There are many ways to add hyperlinks in spreadsheets. The following are the ways supported by MarkdownTableMaker:

  • =HYPERLINK("http://example.com/", "Foo")
  • =HYPERLINK("https://example.com" & A1, "Meh")
  • =HYPERLINK("https://example.com" & foo!A1, "Bah")
  • =HYPERLINK("https://example.com/" & foo!A1, """Free""")
  • =HYPERLINK("https://example.com/" & foo!A1, """""Free""""")
  • =HYPERLINK("https://example.com/" & foo!A1, """""""""Free""""""""")

You may experience formula parse errors in Google Sheets if you use an a “bad pair” of quotes:

  • =HYPERLINK("https://example.com/" & foo!A1, ""Free"")
    • #ERROR: Formula parse error
    • FIX: Use three quotes on each side, instead.
  • =HYPERLINK("https://example.com/" & foo!A1, """"Free"""")
    • #ERROR: Formula parse error
    • FIX: Use fix quotes on each side, instead.

Published by

Bitwise Thermodynamics

Developer of software for #edtech and #adtech.