presumably you have a list or table of the values that correspond to fly
etc.That table can be on the same worksheet or a different one,then you can
use the tried and true vlookup
say your table is on sheet 2 a1:b4
in b1 of sheet 1 type =VLOOKUP(A1,Sheet2!$A$1:$B$4,2) and copy down.
This assumes that he table has fly ,bird,spider etc listed in column a and
the values corresponding listed in column b

paul

remove nospam for email addy!



"paddy 247" wrote:

hi im trying to make a formaula on excel .2003
exmaple= colume A row 1 =fly then it will auto put in colume B row 1 2341
and so on .
if you could help me take would be must greatful.

paddy