SOLVED

formula help for hyperlink

%3CLINGO-SUB%20id%3D%22lingo-sub-1344160%22%20slang%3D%22en-US%22%3Eformula%20help%20for%20hyperlink%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1344160%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20formula%3A%20%3DHYPERLINK(%22%3CA%20href%3D%22https%3A%2F%2Fwww.domainname.com%2Fcategory%2F%26quot%3B%26amp%3BA2%26amp%3BK2%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.domainname.com%2Fcategory%2F%22%26amp%3BA2%26amp%3BK2%3C%2FA%3E)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20put%20a%20%2F%20between%20the%20%26amp%3BA2%20and%20%26amp%3BK2%20and%20I%20can't%20figure%20out%20a%20way%20to%20escape%20the%20%2F%20so%20the%20formula%20works.%26nbsp%3B%20Any%20help%20would%20be%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1344160%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1344203%22%20slang%3D%22en-US%22%3ERe%3A%20formula%20help%20for%20hyperlink%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1344203%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F639963%22%20target%3D%22_blank%22%3E%40david-madfish%3C%2FA%3E%26nbsp%3BUse%20below%20formula%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DHYPERLINK(%22%3CA%20href%3D%22https%3A%2F%2Fwww.domainname.com%2Fcategory%2F%26quot%3B%26amp%3BA2%26amp%3B%26quot%3B%2F%26quot%3B%26amp%3BK2%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.domainname.com%2Fcategory%2F%22%26amp%3BA2%26amp%3B%22%2F%22%26amp%3BK2%3C%2FA%3E)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3EKapil%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted
Best Response confirmed by david-madfish (New Contributor)
Solution

@david-madfish Use below formula:

 

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

 

Regards

Kapil

Highlighted

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

Highlighted

@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