function with 'contain'
=IF(ISERROR(FIND("Adam",A1)),0,1)
"lucas" wrote:
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
|