Try
=IF(ISNUMBER(SEARCH("store",A1),"A","")
change SEARCH to FIND to make it case sensitive.
"Newberry" wrote in message
...
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
|