Hi there,

Probably an easy one but I have a column with number values in each cell. I want to replace these number values with the relevant text string for that value- so if the cell is 1- then I want to replace that with "RED", if it is 2, then "YELLOW", 3 then "GREEN" and so on.

Any formula ideas for this?