| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to Replace Numbers with Phrases
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. -- Jerry |
|
#2
|
|||
|
|||
|
On Wed, 29 Jun 2005 04:39:03 -0700, "Jerry Arnone, PMP"
wrote: 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. Look at HELP for VLOOKUP for how to do this. Another options would be to use CHOOSE. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Replace Numbers with Phrases | Excel Discussion (Misc queries) | |||
| Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
| greater than replace numbers | Excel Worksheet Functions | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| How to Replace numbers and text with numbers only? | Excel Worksheet Functions | |||
Linear Mode
