Sensible Search Function

[Alan Little]

I want column B to have a '1' if column A has the letter 'Z' in it, and to
have nothing if 'Z' is not present.

Unfortunately, both SEARCH and FIND return a #VALUE! error if the search
value is not present, rather than returning a zero or some such thing,
which would make a lot more sense. What I end up with is "If 'Z' is
present, display a '1', otherwise throw an error." Not really useful.

Anyone have an idea how I can do what I'm trying to do?

 

[Peo Sjoblom]

Try

=IF(ISNUMBER(FIND("Z",A1)),1,"")

 

[Alan Little]

Carved in mystic runes upon the very living rock, the last words of Peo
Sjoblom of microsoft.public.excel.worksheet.functions make plain:

Try

=IF(ISNUMBER(FIND("Z",A1)),1,"")

That did it. Thanks.