software

Hi Guys,

If e.g. in cell A1 I have following text 'Adam has 7 apples' is there any
formual that would return in e.g. cell A2 '1' or 'true' or whatever if A1 has
contains word 'Adam'. So in other words I'm looking for sth like this: = if
A1 contains 'Adam' then in A2 return 1; if not then return 0.

lucas

=IF(ISERROR(FIND(quot;Adamquot;,A1)),0,1)

quot;lucasquot; wrote:

gt; Hi Guys,
gt;
gt; If e.g. in cell A1 I have following text 'Adam has 7 apples' is there any
gt; formual that would return in e.g. cell A2 '1' or 'true' or whatever if A1 has
gt; contains word 'Adam'. So in other words I'm looking for sth like this: = if
gt; A1 contains 'Adam' then in A2 return 1; if not then return 0.
gt;
gt; lucas

=ISNUMBER(FIND(quot;Adamquot;),A1)

will return TRUE or FALSE

=--ISNUMBER(FIND(quot;Adamquot;),A1)

will return 1 or 0

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;lucasquot; gt; wrote in message
...
gt; Hi Guys,
gt;
gt; If e.g. in cell A1 I have following text 'Adam has 7 apples' is there any
gt; formual that would return in e.g. cell A2 '1' or 'true' or whatever if A1
has
gt; contains word 'Adam'. So in other words I'm looking for sth like this: =
if
gt; A1 contains 'Adam' then in A2 return 1; if not then return 0.
gt;
gt; lucas
BTW, use

=--ISNUMBER(SEARCH(quot;Adamquot;,A1))

if you don't need case-sensitive

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;lucasquot; gt; wrote in message
...
gt; Hi Guys,
gt;
gt; If e.g. in cell A1 I have following text 'Adam has 7 apples' is there any
gt; formual that would return in e.g. cell A2 '1' or 'true' or whatever if A1
has
gt; contains word 'Adam'. So in other words I'm looking for sth like this: =
if
gt; A1 contains 'Adam' then in A2 return 1; if not then return 0.
gt;
gt; lucas
thx. it helps!

quot;bpeltzerquot; wrote:

gt; =IF(ISERROR(FIND(quot;Adamquot;,A1)),0,1)
gt;
gt; quot;lucasquot; wrote:
gt;
gt; gt; Hi Guys,
gt; gt;
gt; gt; If e.g. in cell A1 I have following text 'Adam has 7 apples' is there any
gt; gt; formual that would return in e.g. cell A2 '1' or 'true' or whatever if A1 has
gt; gt; contains word 'Adam'. So in other words I'm looking for sth like this: = if
gt; gt; A1 contains 'Adam' then in A2 return 1; if not then return 0.
gt; gt;
gt; gt; lucas

thx Bob!

quot;Bob Phillipsquot; wrote:

gt; BTW, use
gt;
gt; =--ISNUMBER(SEARCH(quot;Adamquot;,A1))
gt;
gt; if you don't need case-sensitive
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;lucasquot; gt; wrote in message
gt; ...
gt; gt; Hi Guys,
gt; gt;
gt; gt; If e.g. in cell A1 I have following text 'Adam has 7 apples' is there any
gt; gt; formual that would return in e.g. cell A2 '1' or 'true' or whatever if A1
gt; has
gt; gt; contains word 'Adam'. So in other words I'm looking for sth like this: =
gt; if
gt; gt; A1 contains 'Adam' then in A2 return 1; if not then return 0.
gt; gt;
gt; gt; lucas
gt;
gt;
gt;