returning a value if a cell contains certain text

  • Thread starter Thread starter brian
  • Start date Start date
B

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
 
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)
 
this formula will not return the blank instead #value!

do you know why this is happening

Thank You
Brian
 
=IF(COUNT(SEARCH("all",B1)),"X","")

brian said:
this formula will not return the blank instead #value!

do you know why this is happening

Thank You
Brian
Click to expand...
 
Back
Top