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

In Excel
Cell 1 contains data from 4 references, separated with chopsticks ||
http://sitename.ru/catalog/zhenshchinam///http://sitename.ru/catalog/muzhchinam///http://sitename.ru/catalog/param///http://sitename.ru/info/garanty/

Cell 2 contains the parameter
?yclid=423424
We need to set the parameter from cell 2 at the end of each link from cell 1.
Sample output:
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
July 4th 19 at 23:57
1 answer
July 4th 19 at 23:59
Solution
You've found the solution )) did the change sticks + hitch last reference.
It is desirable to record the formula - adelbert_Rayn commented on July 5th 19 at 00:02

Find more questions by tags Excel