I have imported data from a database.
One column contains comments which might include words such as:-
store
compound
laundry

If one of the above words is included in the text cell I would like to
assign a code to it in an adjacent column, i.e.
store A
compound B
laundry C
Is this possible
thanks
Newberry

--
Remove DOG from address