returning a value if a cell contains certain text

[brian]

I want cell A1 to return an "X" if cell B1 contains
specific text such as the word "all" or a portion of a word
such as "Fall"
A1 B1
X 2/all

blank 2

X 3/fall

and also if instead of an X how can I use a check mark
symbol.

Thanks
Brian

 

[Bob Phillips]

Brian,

In A1 put this formula

=IF(FIND("all",B1)>0,"a","")

and use a font of Marlett

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[brian]

this formula will not return the blank instead #value!

do you know why this is happening

Thank You
Brian

 

[Jim]

Try this:
=IF(ISERROR(FIND("all",B1)),"","a")

 

[Aladin Akyurek]

=IF(COUNT(SEARCH("all",B1)),"X","")

this formula will not return the blank instead #value!

do you know why this is happening

Thank You
Brian