formulas with text

[Lindsay]

I have text in column B, all I need to do is create a formula so that when I
put in text in column B, it will create a number in column C! For instance, I
have CXO in column B, I need it to put 25 in column C everytime I type this.
I know this is a simple function, but have not used this version of Excel
before. Thanks in advance for any help!

[Mallycat]

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