IF formula for text string

[IanJ]

Hi

I want to locate a text string within a row of cells, and just return a 1 if present, and a 0 if absent.

I currently have =IF($A1:$E1="text*",1,0) entered as an array formula ... but it doesn't work.
How do I use the wildcard character to locate the text, and cover the entire range of cells?

Thanks!

[oldchippy]

Try this,

=IF(COUNTIF(A1:A4,"*")>0,1,0)

[IanJ]

Great - thanks

[oldchippy]

Glad to help - thanks for the feedback