SOLVED

formula help for hyperlink

Copper Contributor

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 would be appreciated.

3 Replies
best response confirmed by david-madfish (Copper Contributor)
Solution

@david-madfish Use below formula:

 

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

 

Regards

Kapil

@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.

@david-madfish You can press on Mac

 

  1. Alt + [ produces an opening double curly quote ( “ )
  2. Alt + Shift + [ produces a closing double curly quote ( ” )

Regards

Kapil

1 best response

Accepted Solutions
best response confirmed by david-madfish (Copper Contributor)
Solution