Using the concatenate function with complicated text

**moty99** · 10-17-2010, 07:03 AM

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** · 10-17-2010, 07:19 AM

If we say use a place holder link in T1:

T1:
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=^1^&companyID=^2^&subDataType=0

Then

T5:
=SUBSTITUTE(SUBSTITUTE($T$1,"^1^",A5),"^2^",Q5)
copied down

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

**moty99** · 10-18-2010, 10:18 AM

Thank you very much for your help.

Using the concatenate function with complicated text

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Using the concatenate function with complicated text

Re: Using the concatenate function with complicated text

Re: Using the concatenate function with complicated text

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions