Try...

B1, copied down:

=ISNUMBER(SEARCH("house",A1))

Hope this helps!

In article , "John"
wrote:

Dear all,
in a colomun I would lik to find out a certain word (alone or part of few
other words) and get the result True or Falso in another column.
For example

A B
house True
housewife True
house in a village True
home False
isolated house True

Thanks for your help and regards
John