I am using two different data sets from; one from World Bank and another one from IMF. The name of the countries in their database differs slightly for some countries.
I am interest in finding a faster way to merge them without having to change the name of the countries in the excel file.


Differences:

WB
IMF
Congo, Dem. Rep. Congo, Democratic Republic of
Egypt, Arab Rep. Egypt
Korea, Rep. Korea, Republic of
Venezuela, RB Venezuela, Republica Bolivariana de
P.S. There are some more differences in the dataset.