I have multiple cells in a spreadsheet which lists two character country ISO codes in a single cell like so:
CA, MX, US
CA, MX, US
CA, CR, MX, US
AD, AE, AR, AT, AU, BD, BE, BG, BO, BR, CH, CI, CL
CA, MX, US
GB, US
I have another sheet which lists the ISO code and full country name.
I'd like to replace the ISO codes with the full country names.
Does anyone have any suggestion of how I can go about this?
Thanks