Forum Discussion
Solved
Cannot concatenate a hyperlink from another cell
I am working with office 365 and I have done this in previous versions but its not working now. I have a site with a html pages like 1.html, 2, html etc. If I write in a cell http://www.mysite.co...
Hi h-i-k ;
I have tried your topic.
You must add http: // or https: // before the link
Like this :
=hyperlink("http://www.mysite.com/www.mysite.com/" & indirect("a2") &".html",a2)
You will find the file attachments the file that I created
Hi h-i-k ;
I have tried your topic.
You must add http: // or https: // before the link
Like this :
=hyperlink("http://www.mysite.com/www.mysite.com/" & indirect("a2") &".html",a2)
You will find the file attachments the file that I created
Thanks AbdallahBeraida. I thought I had tried that also but I see it works, so I guess I didn't.