This is a bit complex and it may well not be a task to which Excel is best suited, but here’s what it is: In a worksheet I have a column containing text strings consisting of several phrases separated by commas. What I’d like to do is to extract all the unique expressions, either into one big string or into several.
So basically, with input:
Montreal, metro, bus, train Montreal, train Montreal, bus map, train map, metro map London, bus map
I’d like to get either:
bus bus map London metro metro map Montreal train train map
or at least
bus, bus map, London, metro, metro map, Montreal, train, train map
Is this possible?