Search for specific words

  • Thread starter Thread starter Newberry
  • Start date Start date
N

Newberry

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
 
Try

=IF(ISNUMBER(SEARCH("store",A1),"A","")

change SEARCH to FIND to make it case sensitive.
 
Dave,
thanks for taking the time to reply.
When I enter your formula I get an error, I think one of the closing
brackets is missing from the formula but I'm not able to correct it.
Newberry

Dave R. said:
Try

=IF(ISNUMBER(SEARCH("store",A1),"A","")

change SEARCH to FIND to make it case sensitive.
Click to expand...
 
Following up my previous post, the following works for me,
=IF(ISNUMBER(SEARCH("store",A1)),"A","").
I added a second close bracket after the cell reference
Newberry

Newberry said:
Dave,
thanks for taking the time to reply.
When I enter your formula I get an error, I think one of the closing
brackets is missing from the formula but I'm not able to correct it.
Newberry
Click to expand...
 
Back
Top