Search and translate
 

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

Search and translate
 

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

"Matt" wrote:

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

Search and translate
 

Put this in B1:

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

and copy down to B5.

Hope this helps.

Pete

On Jun 24, 1:43*pm, Matt wrote:
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