Re: how can I search a field for a particular word
- From: "Max" <demechanik@xxxxxxxxx>
- Date: Tue, 2 Aug 2005 09:22:14 +0800
Assume data in C2 down
If it's to be case sensitive,
Put in say, D2:
= IF(ISNUMBER(FIND("USDA",C2)),1,"")
Copy D2 down as far as required
Replace FIND with SEARCH if it's to be case insensitive
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"brantty" <brantty@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0EE68691-CA33-4E4D-8F6D-33AA7C72744F@xxxxxxxxxxxxxxxx
> I have a large document where in column C contains a sentence. I need a
> formula that will look in Column C, identify the word "USDA" and populate
a
> new column with a 1. Can anyone help me with this?
.
- Follow-Ups:
- Re: how can I search a field for a particular word
- From: brantty
- Re: how can I search a field for a particular word
- References:
- how can I search a field for a particular word
- From: brantty
- how can I search a field for a particular word
- Prev by Date: Re: MAX/MIN with SUMPRODUCT
- Next by Date: Re: how can I search a field for a particular word
- Previous by thread: how can I search a field for a particular word
- Next by thread: Re: how can I search a field for a particular word
- Index(es):
Relevant Pages
|
