Is there an excel formula that will replace a number value with a line of
text? Example if I type "1" into the cell it will be replaced with "final
draft", and if I type "2" it will be replaced with "rough draft"

I suggest you to use an auxiar cell with:

=if(a1="1","Final Draft",if(a1="2","rough draf",false))

replace is possible using "auto correct", but if you need to type 1 or 2 it
will be replaced..

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"B-positive" escreveu:

Is there an excel formula that will replace a number value with a line of
text? Example if I type "1" into the cell it will be replaced with "final
draft", and if I type "2" it will be replaced with "rough draft"

Use a number format (Format/Cells, click Custom category):
[=1]"final draft";[=2]"rough draft";General


"B-positive" wrote:

Is there an excel formula that will replace a number value with a line of
text? Example if I type "1" into the cell it will be replaced with "final
draft", and if I type "2" it will be replaced with "rough draft"

Can this only be used with two numbers? What if 1 & 2 = final and 3 & 4 =
rough?
thanks - just learning

dp

"Bob Umlas, Excel MVP" wrote:

Use a number format (Format/Cells, click Custom category):
[=1]"final draft";[=2]"rough draft";General


"B-positive" wrote:

Is there an excel formula that will replace a number value with a line of
text? Example if I type "1" into the cell it will be replaced with "final
draft", and if I type "2" it will be replaced with "rough draft"

To Bob Umlas,

This works but it seems to work only for two variables ie (1 or 2) but I
can't seem to get it to work for more than 2. Is there another trick to that?

Hi B,

You could use Auto Correct replace text as you type.
Just use an odd key combination that you are not
likely to use anywhere else e.g.
|1 |2 |3
or maybe
...1 ..2 ..3
or
zz1 zz2 zz3
or......whatever!

HTH
Martin


"B-positive" wrote in message
...
Is there an excel formula that will replace a number value with a line of
text? Example if I type "1" into the cell it will be replaced with "final
draft", and if I type "2" it will be replaced with "rough draft"