Search and translate

[Matt]

I need to search a column for specific characters and "translate" the
characters into meaningful explanations in the next column.
i.e. Column A, cells 1 thru 5 have the following characters
1,2,3
1,2
2
1,3
2,3

I need to "translate" these codes to be meaningful, so column B, cells 1
thru 5 would read:
red, green, black
red, green
green
red, black
green, black

Any Ideas?
Thx, Matt

 

[Sam Wilson]

Ctrl + H is find and replace - you could do that on the range you require and
tell it to replace "1" with "Red" etc.

Sam

 

[Pete_UK]

Put this in B1:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"1","Red"),"2","Green"),"3","Black")

and copy down to B5.

Hope this helps.

Pete