Search for specific words

Try

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

change SEARCH to FIND to make it case sensitive.


"Newberry" <newberryDOG@zoom.co.uk> wrote in message
news:42deb653$0$1261$da0feed9@news.zen.co.uk...
> 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
>
>

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." <daverx@hotmail.com> wrote in message
news:%238Ad7TXjFHA.1968@TK2MSFTNGP14.phx.gbl...
> Try
>
> =IF(ISNUMBER(SEARCH("store",A1),"A","")
>
> change SEARCH to FIND to make it case sensitive.
>
>
> "Newberry" <newberryDOG@zoom.co.uk> wrote in message
> news:42deb653$0$1261$da0feed9@news.zen.co.uk...
>> 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
>>
>>
>
>

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" <newberryDOG@zoom.co.uk> wrote in message
news:42e009ae$0$30661$db0fefd9@news.zen.co.uk...
> 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." <daverx@hotmail.com> wrote in message
> news:%238Ad7TXjFHA.1968@TK2MSFTNGP14.phx.gbl...
>> Try
>>
>> =IF(ISNUMBER(SEARCH("store",A1),"A","")
>>
>> change SEARCH to FIND to make it case sensitive.
>>
>>
>> "Newberry" <newberryDOG@zoom.co.uk> wrote in message
>> news:42deb653$0$1261$da0feed9@news.zen.co.uk...
>>> 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
>>>
>>>
>>
>>
>
>

Try

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

change SEARCH to FIND to make it case sensitive.


"Newberry" <newberryDOG@zoom.co.uk> wrote in message
news:42deb653$0$1261$da0feed9@news.zen.co.uk...
> 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
>
>

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." <daverx@hotmail.com> wrote in message
news:%238Ad7TXjFHA.1968@TK2MSFTNGP14.phx.gbl...
> Try
>
> =IF(ISNUMBER(SEARCH("store",A1),"A","")
>
> change SEARCH to FIND to make it case sensitive.
>
>
> "Newberry" <newberryDOG@zoom.co.uk> wrote in message
> news:42deb653$0$1261$da0feed9@news.zen.co.uk...
>> 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
>>
>>
>
>

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" <newberryDOG@zoom.co.uk> wrote in message
news:42e009ae$0$30661$db0fefd9@news.zen.co.uk...
> 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." <daverx@hotmail.com> wrote in message
> news:%238Ad7TXjFHA.1968@TK2MSFTNGP14.phx.gbl...
>> Try
>>
>> =IF(ISNUMBER(SEARCH("store",A1),"A","")
>>
>> change SEARCH to FIND to make it case sensitive.
>>
>>
>> "Newberry" <newberryDOG@zoom.co.uk> wrote in message
>> news:42deb653$0$1261$da0feed9@news.zen.co.uk...
>>> 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
>>>
>>>
>>
>>
>
>

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

Try

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

change SEARCH to FIND to make it case sensitive.


"Newberry" <newberryDOG@zoom.co.uk> wrote in message
news:42deb653$0$1261$da0feed9@news.zen.co.uk...
> 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
>
>

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." <daverx@hotmail.com> wrote in message
news:%238Ad7TXjFHA.1968@TK2MSFTNGP14.phx.gbl...
> Try
>
> =IF(ISNUMBER(SEARCH("store",A1),"A","")
>
> change SEARCH to FIND to make it case sensitive.
>
>
> "Newberry" <newberryDOG@zoom.co.uk> wrote in message
> news:42deb653$0$1261$da0feed9@news.zen.co.uk...
>> 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
>>
>>
>
>

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" <newberryDOG@zoom.co.uk> wrote in message
news:42e009ae$0$30661$db0fefd9@news.zen.co.uk...
> 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." <daverx@hotmail.com> wrote in message
> news:%238Ad7TXjFHA.1968@TK2MSFTNGP14.phx.gbl...
>> Try
>>
>> =IF(ISNUMBER(SEARCH("store",A1),"A","")
>>
>> change SEARCH to FIND to make it case sensitive.
>>
>>
>> "Newberry" <newberryDOG@zoom.co.uk> wrote in message
>> news:42deb653$0$1261$da0feed9@news.zen.co.uk...
>>> 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
>>>
>>>
>>
>>
>
>