There are no formulas that will do that, only VBA
You can however use a vlookup table and get the desciption in the adjacent
cell,
in either way you need to make a list of all replacement/descriptions and
their numbers

Regards,

Peo Sjoblom

"Steinbart" wrote:

I want to enter a number into a cell and have it replaced with a description.
i.e. If I enter "1" in a cell it will replace it with "frame." If I enter
"2" it will replace it with "carpet." I need an excel fromula to tell the
program to do this.