Hi all
I am trying to input a value in cell A1 depending on that value entered in cell a2 it will show the country code
For example in A1 I enter the following : US1 BC25 IN A2 it should show "USA/AMERICA"
likewise UK25 BD35 IN A2 It should show "UK"
IN534372 IN A2 it should show "INDIA"
Based on the first two alphabets it should show the country code
What would be the best code
Bookmarks