I've got a list in "column A" of around 6000 lines which contains key words which I want to extract to "Column b" if It matches but it can match on more than one word .
Six Nations Ireland v England
FA cup Semi Final Chelsea v Liverpool @ Old Trafford
Ideally I would like to extract the first Town/Country as this is where the event is held unless the @ symbol is used then it's the last Toen/Country as in the FA cup example.
Thanks in Advance