Sensible Search Function

  • Thread starter Thread starter Alan Little
  • Start date Start date
A

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?
 
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,"")
Click to expand...

That did it. Thanks.
 
Back
Top