Forum Discussion

Copper Contributor

Apr 28, 2020

Solved

formula help for hyperlink

I have a formula: =HYPERLINK("https://www.domainname.com/category/"&A2&K2) I need to put a / between the &A2 and &K2 and I can't figure out a way to escape the / so the formula works. Any help w...

excel

Formulas and Functions

jukapil
Apr 28, 2020
david-madfish Use below formula:

=HYPERLINK("https://www.domainname.com/category/"&A2&"/"&K2)

Regards
Kapil

jukapil

MCT

Apr 28, 2020

david-madfish Use below formula:

=HYPERLINK("https://www.domainname.com/category/"&A2&"/"&K2)

Regards

Kapil

david-madfish
Copper Contributor
Apr 28, 2020
jukapilI thought I had tried that but when I pasted your response it worked. I'm wondering if my double quotes key on my Mac was the difference. Thank you.
- jukapil
  MCT
  Apr 28, 2020
  david-madfish You can press on Mac
  
  Alt + [ produces an opening double curly quote ( “ )
  Alt + Shift + [ produces a closing double curly quote ( ” )
  Regards
  Kapil