Hi All,

There are 2 columns in the Excel column A have name of network paths separated ";", in column B i also have network paths but its multiple separated by ";",

example 1
in A1 i have "\\fileserver\SharedDocs; \\company\marketing; \\home\engineering"
in B1 i have "D:\Games\Pokemon; E:\Music\Pokemon_Symphonic; C:\Program Files\Pokemon_GO"

so i want to take A1 value as a reference and i want in C1 "\\fileserver\SharedDocs; D:\Games\Pokemon, \\company\marketing; E:\Music\Pokemon_Symphonic, \\home\engineering; C:\Program Files\Pokemon_GO"

please give me Excel formula

Thanks

Excel sheet also i have attachedsample excell.xlsx