Why don't you use a Vlookup to do this.

Somewhere on the side create a table that lists the countries in the
first column and the associated numbers in the second.

Then in Column A, enter formula =Vlookup(B2,$AA$1:$AB$100,2,0), where
AA1:AB100 contains your lookup table, then you can copy the formula
down column A.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=489402