SOLVED
Home

Cannot concatenate a hyperlink from another cell

%3CLINGO-SUB%20id%3D%22lingo-sub-386306%22%20slang%3D%22en-US%22%3ECannot%20concatenate%20a%20hyperlink%20from%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-386306%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20working%20with%20office%20365%20and%20I%20have%20done%20this%20in%20previous%20versions%20but%20its%20not%20working%20now.%26nbsp%3B%20I%20have%20a%20site%20with%20a%20html%20pages%20like%201.html%2C%202%2C%20html%20etc.%20%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20write%20in%20a%20cell%20%3CA%20href%3D%22http%3A%2F%2Fwww.mysite.com%2F1.html%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ewww.mysite.com%2F1.html%26nbsp%3B%3C%2FA%3E%20the%20link%20works%20fine%3C%2FP%3E%3CP%3Eif%20I%20have%20a%20list%20of%20numbers%20in%20column%20a%20and%20column%20be%20is%20any%20of%20the%20following%3A%3C%2FP%3E%3CP%3E%3D%22%3CA%20href%3D%22http%3A%2F%2Fwww.mysite.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ewww.mysite.com%2F%3C%2FA%3E%22%20%26amp%3B%20a2%20%26amp%3B%20%22.html%22%3C%2FP%3E%3CP%3E%3Dhyperlink(%22%3CA%20href%3D%22http%3A%2F%2Fwww.mysite.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ewww.mysite.com%2F%3C%2FA%3E%22%20%26amp%3B%20a2%20%26amp%3B%20%22.html%22%2Ca2)%3C%2FP%3E%3CP%3E%3Dhyperlink(%22%3CA%20href%3D%22http%3A%2F%2Fwww.mysite.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ewww.mysite.com%2F%3C%2FA%3E%22%20%26amp%3B%20indirect(%22a2%22)%20%26amp%3B%22.html%22%2Ca2)%3C%2FP%3E%3CP%3EThe%20link%20is%20not%20formed%20properly.%26nbsp%3B%20Even%20in%20the%20case%20of%20the%20first%20if%20I%20copy%20and%20paste%20values%20the%20spreadsheet%20shows%20%3CA%20href%3D%22http%3A%2F%2Fwww.mysite.com%2F1.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ewww.mysite.com%2F1.html%3C%2FA%3E%3C%2FP%3E%3CP%3Ebut%20when%20I%20click%20on%20it%20I%20get%20an%20error%26nbsp%3B%20%22cannot%20connect%20to%20%3CA%20href%3D%22http%3A%2F%2Fwww.mysite.com%2Fa2.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ewww.mysite.com%2Fa2.html%3C%2FA%3E%3C%2FP%3E%3CP%3EIs%20this%20a%20bug%20or%20am%20I%20missing%20something.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHaim%20Katz%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-386306%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EHyperlink%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-394084%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20concatenate%20a%20hyperlink%20from%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-394084%22%20slang%3D%22en-US%22%3Esorry%2C%20should%20add%3A%20those%20are%20links%20to%20web%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-394083%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20concatenate%20a%20hyperlink%20from%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-394083%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F306943%22%20target%3D%22_blank%22%3E%40AbdallahBeraida%3C%2FA%3EI%20am%20having%20a%20problem%20and%20ask%20for%20help%3A%3C%2FP%3E%3CP%3EIn%20a%20spread%20sheet%20I%20have%20a%20column%20H%20filled%20in%20with%20links%2C%20I%20made%20them%20active%20by%20hyperlink%20function%2C%20and%20when%20trying%20to%20use%20it%20-%20every%20link%20sends%20me%20to%20the%20cell%20A1%2C%20i.e.%20doesn't%20work.%20I%20tried%20to%20set%20proper%20configuration%20in%20the%20Edit%20Hyperlink%2C%20nothing%20works.%3C%2FP%3E%3CP%3EWhich%20I%20find%20strange%20as%20I%20have%20been%20using%20hyperlinks%20for%20many%20years%2C%20and%20they%20were%20always%20easily%20activated%20and%20working..%20any%20idea%3F%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-386360%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20concatenate%20a%20hyperlink%20from%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-386360%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F306943%22%20target%3D%22_blank%22%3E%40AbdallahBeraida%3C%2FA%3E.%26nbsp%3B%20I%20thought%20I%20had%20tried%20that%20also%20but%20I%20see%20it%20works%2C%20so%20I%20guess%20I%20didn't.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-386359%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20concatenate%20a%20hyperlink%20from%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-386359%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F305419%22%20target%3D%22_blank%22%3E%40h-i-k%3C%2FA%3E%20%3B%3C%2FP%3E%3CP%3EI%20%3CFONT%3Ehave%20tried%20your%20topic.%20%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3EYou%20must%20add%20%3CSTRONG%3Ehttp%3A%20%2F%2F%3C%2FSTRONG%3E%20or%20%3CSTRONG%3Ehttps%3A%20%2F%2F%3C%2FSTRONG%3E%20before%20the%20link%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3ELike%20this%20%3A%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E%3CSPAN%3E%3Dhyperlink%3CSTRONG%3E(%22%3C%2FSTRONG%3E%3C%2FSPAN%3E%3CA%20href%3D%22http%3A%2F%2Fwww.mysite.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSTRONG%3Ehttp%3A%2F%2F%3C%2FSTRONG%3Ewww.mysite.com%2F%3C%2FA%3E%3CSPAN%3E%22%20%26amp%3B%20indirect(%22a2%22)%20%26amp%3B%22.html%22%2Ca2)%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E%3CSPAN%3EYou%20will%20find%20the%20file%20attachments%20the%20file%20that%20I%20created%26nbsp%3B%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
h-i-k
New Contributor

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 www.mysite.com/1.html  the link works fine

if I have a list of numbers in column a and column be is any of the following:

="www.mysite.com/" & a2 & ".html"

=hyperlink("www.mysite.com/" & a2 & ".html",a2)

=hyperlink("www.mysite.com/" & indirect("a2") &".html",a2)

The link is not formed properly.  Even in the case of the first if I copy and paste values the spreadsheet shows www.mysite.com/1.html

but when I click on it I get an error  "cannot connect to www.mysite.com/a2.html

Is this a bug or am I missing something.

 

Haim Katz

4 Replies
Solution

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/" & 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.

 

@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
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies