Skip to content

Instantly share code, notes, and snippets.

@ademidun
Created January 8, 2023 11:38
Show Gist options
  • Save ademidun/2b530ddd88c74b48fd062ae8e0282809 to your computer and use it in GitHub Desktop.
Save ademidun/2b530ddd88c74b48fd062ae8e0282809 to your computer and use it in GitHub Desktop.
Helpful Google Sheets Functions

Helpful Google Sheets Functions

  1. Paste your function as a markdown
  2. For the example section, copy your table and convert it to markdown with a Table to Markdown Tool and then paste it here.
  3. You might need to surround html code with backticks `` so it renders the html code and not the formatted html

Display a formatted HTML anchor tag Link with text and url as a variable

Formula

=CONCATENATE("<a href=""",A2,""">",B2,"</a>")

Example

url text html
https://atila.ca/blog/tomiwa/the-dispersal-of-human-capital/ Dispersal of Human Capital <a href="https://atila.ca/blog/tomiwa/the-dispersal-of-human-capital/">Dispersal of Human Capital</a>

References

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment