Maybe something like this...

=COUNT(MATCH("*word*",C1:F1,0))

--
Biff
Microsoft Excel MVP


"Vibeke" wrote in message
...
Hi, I have four columns of data (C-F) I need to search for a particular
word.
The data is addresses, i.e. it combines text and numbers and the word I'm
searching for can appear anywhere within it (or not at all). The function
I
require will return 1 if it does and 0 if it does not. Have tried various
iterations of if\search\match and so on to no avail - perhaps because I'm
searching a range of columns rather than a specific cell? I'd appreciate
your
suggestions. Regards,