How to Replace Numbers with Phrases

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to do a simple clean of one column by copying and pasting(finding and replacing) phrases in adj 4
How to Combine two cells (numbers) but not add 7
MS word Find and Replace using Regex - Help required 0
Issue with blanks and spaces 56
View code for removal of unwanted text in cells 4
Formatting one cell based on the contents of another 4
How do you insert a phrase at the start of all cells in a column? 3
Counting and deleting 7

Back
Top