Apr 28 2020 07:34 AM
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.
Apr 28 2020 07:40 AM
Solution@david-madfish Use below formula:
=HYPERLINK("https://www.domainname.com/category/"&A2&"/"&K2)
Regards
Kapil
Apr 28 2020 07:45 AM
@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.
Apr 28 2020 07:48 AM
@david-madfish You can press on Mac
Regards
Kapil
Apr 28 2020 07:40 AM
Solution@david-madfish Use below formula:
=HYPERLINK("https://www.domainname.com/category/"&A2&"/"&K2)
Regards
Kapil