Using the concatenate function with complicated text

[moty99]

Hi,

I have a URL string which i'd like to edit using the concatenate function.
The address for example:
http://www.tase.co.il/TASE/Templates...&subDataType=0


The strings i'd like to replace are '00319012' and '000319'.
These numbers are the share id and company id. I have an excel file with share id's and company id's.
I tried to use the concatenate funtion in this way:

=concanate("http://www.tase.co.il/TASE/Templates/Company/CompanyHistory.aspx?NRMODE=Published&NRORIGINALURL=%2fTASE%2fGeneral%2fCompany%2fcompanyHistoryData%2ehtm%3fsubDataType%3d0%26companyID%3d002215%26shareID%3d01115112&NRNODEGUID=%7b6BC1C307-4BF8-45C7-99EB-07D3F49DDAA0%7d&NRCACHEHINT=Guest&shareID=",A8,"&companyID=",Q8,"&subDataType=0")

but I get an error message.

Can someone help me solve the problem?



Thank you,

Moty

[DonkeyOte]

If we say use a place holder link in T1:

Please Login or Register  to view this content.

Then

Please Login or Register  to view this content.

the strings are too long for you to convert to active links via HYPERLINK function it's that's your intention...

[moty99]

Thank you very much for your help.