If this then that

[B-positive]

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"

 

[Marcelo]

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:

 

[Bob Umlas, Excel MVP]

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

 

[B-positive]

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?

 

[MartinW]

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

 

[dp]

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

dp

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

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"