If cell contains text from list, remove text from that cell

Hi, I have a list of cells that have countries and names, but I want to remove the countries and just leave the names. I have a list of the countries that I want to remove, I just don't know the formula to say if cell A1 contains text from list of cells D1:D26, remove it from cell A1, and so forth. Attached workbook. Any help is greatly appreciated!

Thanks

in D2

=IFERROR(SUBSTITUTE($A1,INDEX($C$1:$C$26,SUMPRODUCT(ISNUMBER(FIND($C$1:$C$26,$A1,1))*ROW($1:$26))),""),"")

"Problem" with "Ireland" and "Nothern Ireland" for 2 cases

Thank you!! I will just make Ireland one item and Northern another in that list.

@D13L

No need to apologise as your solution works perfectly.