I have a cell containing values that are semi column separated and have a value after the :How can I split this info into multiple cells?IDLocations1location A:1,Location B:3, Location C:92location A:4,Location B:10, Location C:44I know all Locations...
here you go14033 - SM Charles Quint:1;14084 - SM Nivelles:1;Ninove:3;Zellik – A :2;14161 - SM Kraainem:1;14013 - SM Seraing:1;14800 - Store candidates:2;Zellik – D :2;14057 - SM De Fre:1;Kobbegem - Hoofdzetel / Siège Social:48;Osseghem - Hoofdzetel /...
There can be many locations up to a couple hundreds.And the locations are not on every line on the same place. I can have a line with location D,J,X and one J,F,X so the output of every line is different.But in theorie i could replicate this formule ...
