Display numerical code
 

How do I make a phrase like "cherry bed" display as a numerical code like
"0042" once it is entered into the spreadsheet?

Display numerical code
 

On Fri, 22 Dec 2006 16:56:00 -0800, catwoman
wrote:

How do I make a phrase like "cherry bed" display as a numerical code like
"0042" once it is entered into the spreadsheet?

Construct a table with the equivalences, and use one of the LOOKUP functions.
--ron

Display numerical code
 

This formula , if put in the next (or any) cell will display 0042 if a1
contains cherry red.........if you want the cell itself to convert over to
0042 when you type in cherry bed, that would take change-event
VBA...........

Vaya con Dios,
Chuck, CABGx3



"catwoman" wrote in message
...
How do I make a phrase like "cherry bed" display as a numerical code like
"0042" once it is entered into the spreadsheet?

Display numerical code
 

"CLR" wrote:
This formula , if put in the next (or any) cell will display 0042 if a1
contains cherry red

Chuck, think you forgot to paste the formula ? <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Display numerical code
 

Lol............sorry, it was past my sleepy-time............thanks for
catching it Max........
here's the formula, depending on how it's spelled <g

=IF(A1="cherry bed","0042","")

....and of course a VLOOKUP could be used instead if there were many
"phrases".

Merry Christmas to all............

Vaya con Dios,
Chuck, CABGx3



"Max" wrote in message
...
"CLR" wrote:
This formula , if put in the next (or any) cell will display 0042 if a1
contains cherry red

Chuck, think you forgot to paste the formula ? <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---