Hi Ryuujin,

You will need to change your Shop 2, 3 & 4 into Shop 2 Shop 3 Shop 4 to eliminate the problem. Use this formula.
If in A1 is Shop 2, 3 & 4 then in B1 put this formula
=SUBSTITUTE(SUBSTITUTE(A1,"&","Shop"),","," Shop")
Then try to do your problem again.