On Sat, 12 May 2007 03:52:00 -0700, Eric
wrote:

Does anyone have any suggestions on how to search for text within a cell?
such as
in cell A1, which contain a text 'I am a boy", then I would like to search
for text "boy" within cell A1, if cell A1 contains this text, then return 1
in cell B1, else return 0.
Does anyone have any suggestions
Thank you in advance
Eric

=COUNTIF(A1,"*boy*")
--ron