I suggest you set up a vlookup table.

Create a table with all the text in 1 column and the numbers in the
next

Say this is range g1:h10
cell g1 cxo h1 25
cell g2 sdf h2 45
etc

enter text (say cxo) in cell a1
put this formula in cell b1
=VLOOKUP(A1,$g$1:$h$10,2,0)
copy the forumula down to cells b2 .. b what ever

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=552888