Search for specific words

Try

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

change SEARCH to FIND to make it case sensitive.


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