In Excel, you need to concatenate with a complex structure, give a formula?

A

Alexander2016-09-15 23:12:02

excel

Alexander, 2016-09-15 23:12:02

In Excel ,
Cell 1 contains data from 4 links separated by ||

http://sitename.ru/catalog/zhenshchinam/||http://sitename.ru/catalog/muzhchinam/||http://sitename.ru/catalog/param/||http://sitename.ru/info/garanty/

Cell 2 contains a parameter.
?yclid=423424
You need to put the parameter from cell 2 at the end of each link from cell 1.
An example of the result:

http://sitename.ru/catalog/zhenshchinam/?yclid=423424||http://sitename.ru/catalog/muzhchinam/?yclid=423424||http://sitename.ru/catalog/param/?yclid=423424>||http://sitename.ru/info/garanty/?yclid=423424

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Alexander, 2016-09-15
@Alexx_ps

That's it, I found a solution myself)) I made a replacement of sticks + a hitch of the last link.