Hi Shawna

don't think you can do it in the same column as code, but if you have a
table with the code in the first column & the data that you want to
substitute for it in another column you can use the VLOOKUP function
e.g. your "lookup" table - assume on sheet2
A B
1 Code Info
2 AAA Animals
3 BBB Birds

the sheet where you want the related data to appear
A B
1 BBB - want "Birds" here

therefore in B1 you can type
=VLOOKUP(A1,Sheet2!$A$2:$B$3,2,0)
this says, lookup the value in A1, in the table in sheet2 and return the
information from the 2nd column where there is an exact match

Hope this helps
Cheers
JulieD

"Shawna" wrote in message
...
I'm sure this is very simple but I cannot figure it out.
I have one column with a number code. Instead of that
number code, I want it to be what the code stands for.
What kind of forumula can I write for this? If I can't
do it within the same column, I can accept doing it in
another column and copying and pasting.

Any suggestions would be greatly appreciated.

Thank you
Shawna