=--(COUNTIF(A1,"*fred*")0)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Tim Sampson" wrote in message
. 2...
Hi

I'm sure this must be the easiest question ever but it's proving very
difficult for me to find in the help and on Google.

What is the Excel function that says "if A1 contains "fred" then 1, else
0".

Note, A1 might contain Fred, Freddy or Alfredo, all should match.

TIA
Tim