Hi Everyone! I am in desperate need for help. I need to extract only country names from a column (over 100,000 rows). I have provided an example screenshot below (and excel workbook with example data) and other formulas I have tried (they seem to only extract the country name if its the only thing present in the cell.
ExcelQuestion.JPG
I need to extract only the country names from Column A (Column A can contain a country name and all sorts of other random data, street addresses, zipcodes, states). These are the formulas I have tried to use without success:
=IFERROR(VLOOKUP(C1,M:M,1,FALSE),"")
=IFERROR(INDEX(D$2:D$250,MATCH(A2,D$2:D$29,0),1),"")
Bookmarks