Hi!
First time posting here. I have to generate daily reports from a program and format them, and I want to try and automate a small function in the report.
I want to grab a 2 letter country code within a string in a cell and have excel spit out the actual name of the country in another column.
Currently, I have =IF(ISBLANK(E6),"",VLOOKUP(E6,Table1[#All],2,)) which requires me to type in the 2 letter code in a column and excel spits out the full country name.
The string I get in the report is "INT-TRAV-2021-06-13-GB--9999999" and I use the "GB" to determine the country. Sometimes the string contains a second country code that we ignore :"INT-TRAV-2021-06-13-DE-ES-9999999" (we only use "DE", we ignore "ES"). The last 7 digits vary because that is the personal identifier.
Does excel has a function that will read the string, identify the 2 letter country code, and spit out the full country name in an adjacent column?
Thanks,
B
Bookmarks