How to Replace Numbers with Phrases

J

Jerry Arnone, PMP

hi all,

I have a cell that has six choices, numbers 1-5 and blank, I need to replace
the cell with a phrase for each different number, and if the cell is blank
leave it blank.

Your help is greatly appreciated.
 
R

Ron Rosenfeld

hi all,

I have a cell that has six choices, numbers 1-5 and blank, I need to replace
the cell with a phrase for each different number, and if the cell is blank
leave it blank.

Your help is greatly appreciated.
Click to expand...

Look at HELP for VLOOKUP for how to do this. Another options would be to use
CHOOSE.


--ron
 
Top