I would like to do a replace on multiple strings within a cell, based upon a lookup table.
My lookup table has two columns:
AUSTRIA | AT BRAZIL | BR COLOMBIA| CO
My data table has two columns:
Apples | AUSTRIA,COLOMBIA Banana | BRAZIL,AUSTRIA
I want the values in the data table to be replaced by the values in the lookup table (which, being every ISO country code, is quite long).
Apples | AT,CO Banana | BR,AT
Any ideas? Avoiding VBA is preferable!