Forum Discussion
Cannot concatenate a hyperlink from another cell
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
AbdallahBeraidaI am having a problem and ask for help:
In a spread sheet I have a column H filled in with links, I made them active by hyperlink function, and when trying to use it - every link sends me to the cell A1, i.e. doesn't work. I tried to set proper configuration in the Edit Hyperlink, nothing works.
Which I find strange as I have been using hyperlinks for many years, and they were always easily activated and working.. any idea?
thanks
- sorry, should add: those are links to web
Thanks AbdallahBeraida. I thought I had tried that also but I see it works, so I guess I didn't.
