I have one column with concatenated words, say international city names. Each cell in this column is different, but city names overlap. And I have one cell with concatenated words, say only German city names.
I want to have the international cities limited to just the German cities specified in the control cell, if any of these appear in the cell of the data column. So, one cell might be empty (no German city), one might just be
Frankfurt,Munich, another one
Berlin,Hamburg,Munich, provided the control cell includes these cities.
If much easier the control cell could also be another column, i.e not a concatenated string.