Text

  • Thread starter Thread starter Robo
  • Start date Start date
R

Robo

I would like a formula that would give a result "Yes" or "No" if a tex
field contained the word Tower, is this possible?
Thank
 
Jason Morin wrote...
=IF(A1="Tower","Yes","No") ...
-----Original Message-----

The word 'contained' in the OP is ambiguous. It could also mean

=IF(COUNTIF(A1,"*Tower*"),"Yes","No"
 
It's not ambiguous to me.
-----Original Message-----
Jason Morin wrote... possible?

The word 'contained' in the OP is ambiguous. It could also mean

=IF(COUNTIF(A1,"*Tower*"),"Yes","No")
 
I read in microsoft.public.excel.worksheet.functions that hgrove
Jason Morin wrote...
..

Does the phrase 'Tower of Ignorance' *contain* the word Tower?
Does the phrase 'Tower of barges'? (;-)
 
Back
Top